Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to prepare a chart with different ranks for one selected client (CMU2_NM)
CMU2_NM is not part of dimension. Chart dimension is - CALENDAR_PERIOD since the ranks are needed for different periods. 4 possible values for CALENDAR_PERIOD are loaded using inline load.
Added below expression for the chart -
=if(CALENDAR_PERIOD='YTD 2011',
Aggr(rank(sum({<CMU2_NM={"*"}>}F_CV_YTD)),CMU2_NM),
if(CALENDAR_PERIOD='YTD 2010',
Aggr(rank(sum({<CMU2_NM={"*"}>}F_CV_PREV_YTD)),CMU2_NM)))
Now the problem is only first rank YTD 2011 is displayed... other ranks are not displayed and instead it shows "-". Please refer to attached image..
Can someone help please to fix above expression...
Bump!
Appreciate if someone can point me in a right direction to fix this...