Hello, here is my dataset :
What I would like to have is a filter on Campagne which shows all the other Campagne if the Contract number is the same. I explain myself. If I click on Campagne 3 in my filter, I want to see 1, 2, 3 and the attribution (the attribution by Campagne, not a Sum). Here is the expected result :
For now, the only solution that I have is to use a "temporary" table. But it's not optimal because I have to duplicate the data.
Any idea?