Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a comparative analysis chart which uses selection over 2 different groups/states (Dim Group 1 and Dim Group 2).
I have managed to make the comparative analysis work but i am trying to make the label of the chart also dynamic so that when a user selects Year and Quarter for Period 1 of analysis, in the table it shows that particular selection (for example: Q2,2010) and same for Period 2(Q1,2012)Joshua Burton.
Thanks
Vipul
Yes in the label for Period 1 you can put:
=Qtr & ',' & Year
And in the label for Period 2 you can put:
=MinString( {Altstate1} Qtr) & ',' & MinString( {Altstate1} Year)
Thanks Petter,
=MinString( {Altstate1} Qtr) & ',' & MinString( {Altstate1} Year)
The above expression was helpful in making it to display the period that was selected. But this is not working correctly in case of multiple selection of year and Quarter.
I tried using :
=GetFieldSelections({[Dim Group 1]}Cal_Quarter) & ',' & GetFieldSelections( {[Dim Group 1]}Cal_Year)
But it gives an error.
Could you suggest, how can i get that working for multiple selections.
Thanks
VN