One Filter for Two Alternate States

[#1]

Hi Community,

I have two compare two scenarios and for that I have two alternate state (as1,as2).

For this I have 5 (5X2) different filters, out of that three filter should be same for both states.

So is there any way I can use one filter for two alternate states.

Thanks in Advance

Prakash

[Anonymous]

Hi I tried the logic provided by you but I am not able to use Shop_Name filter as common for both states.Please see the sample file attached.

[MuraliPrasath]

Thanks bro, I had same query and got this fixed. 

[mariekaram]

where i can write this expression

Sum({$*[Alternate State1]} Sales)//$ represents default state