I need help on the below query.
I have two columns A & B. I need to use these as a single drop down .i.e. click on filter and it shows A and B
When a User choose A the KPI calculation changes to SUM(A) and when it chooses to B it shows a SUM(B).
Is it possible or not? If yes please guide me.