How to use a single pie chart with a filter to flash in different details

[chris_jibin]

How to use a single pie chart with a filter to flash in different details. Accoording to the value selected in the filter the underlying columns in the calculations must change. Is it possible this way . Or should we create different metrics for each different columns.

[NitinK7]

you can try like

if(getfiledselection(your filter name)='value', sum(sales), sum(revenue))