Filter with change in Aggregations

[Anonymous]

Hello Everyone,

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.

Cheers

DC