Alternate state

[Nagaraju_KCS]

HI Community,

Can we use Alternate state in Layout Condition..???

Suppose i have 2 Alternate Selections, If i am select 2 States i want to display 3 chart..

Is any possibility??

Thanks

[Anonymous]

to select the alterative state and give the column name then it is working and give the same name in the chart also give the same name then it working

[settu_periasamy · Accepted solution]

Hi,

May be the alternate (Not sure working for you )

=Rangesum(if(not isnull(Only({G1}DivisionName)),1),
if(not isnull(Only({G1}Category)),1),
if(not isnull(Only({G1}ProductName)),1))>0 and

Rangesum(if(not isnull(Only({G2}DivisionName)),1),
if(not isnull(Only({G2}Category)),1),
if(not isnull(Only({G2}ProductName)),1)) >0

[settu_periasamy]

Hi,

sunindia‌ Expression is also Correct. You Can give the Credits (helpful/Correct) to him also....