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

[DutchArjo]

I have succesfully used a state in a chart to have the filter applied although the chart has a different state.

Now I have another chart on which I want to have a filter applied where that filter is in a different state.

Now the filter does not work unfortunately.

I do not understand what is going wrong.

The simple expression that works is:

Sum([ATNL_GRC statushouders PP+vbt])

After I change it to:

Sum({$<[ATNL_Luchtvaartmaatschappij]={[standaard-state]}>} [ATNL_GRC statushouders PP+vbt])

the chart has no values. ATNL_Luchtvaartmaatschappij is in the <standaard-state>.

using a state like this worked for me in a different dashboard where I used this expression:

=count({<[GAA_Controle]={'Ja'}, PRO_Centrumbrigade={[standaard_state]}>} GAA_Controle)/count(GAA_Controle)

I cannot find where my expression is going wrong or why it is not working as expected.