Requirement

[Anonymous]

i have two alternate states defined in my sheet,state 1 and state2

state1 in chart shud show the selected dimension (whatever is from filter)

and state 2 expressions shud show everything excluding the state1 expressions,

so say:

count({state1 * $}id)

how shud the state 2 expressions wud be written?

[Anonymous]

can anyone please help for the above query

[Gysbert_Wassenaar]

try this: count( { 1 - (state1*$) } id )

[Anonymous]

so if there are no selections made its just showing me state 1 bar,

what will be the state 2 den?

[Gysbert_Wassenaar]

empty