Hi,
*Can both alternate and default state selections in a list box
influence a single chart*?
I have 3 Period selections. 1st period is in default state and remaining 2
will have alternate states. And there are 3 different set expressions
(expression1 for default and remaining 2 has scope for alternate states)
for 3 different periods in the list box.
So, when 1st period is selected, only 1st column of the chart should change
and remaining columns should not get affected. But in my case, all the
remaining columns go blank. How can I override the alternate state when
default period selection is made? What changes has to be done in the
expression having alternate states?
Period 1 -> current month, period 2 -> previous month, period 3-> previous
quarter.
my expression for alternate states looks like this:
=if(Count(distinct Period2)=1 ,sum( {Period2< =Period2 >}
Amount)/1000000,
sum( = '$(vPreviousMonth)' >}Amount)/1000000)
Any help would be appreciated, Thanks !
Regards,
Rakshita.