Hi All,
Can any one help me on the following scenario, I have generated a stacked bar chart with fiscalyear-Period ,Manager Drilldown Group as dimensions , fiscalyear-Period has 13 periods in it, like 2013-01,2013-02......2015-01,2015-02,2015-03.....2015-013 , my scenario is I need to show fiscalyear-Period 13 values back from the maximum period.
for this I have used expression as
sum({1<fiscalyear-Periodnum={">$(=max(fiscalyear-Periodnum)-13)<=$(=max(fiscalyear-Periodnum))"}>}sales)
Here because of the Identifier '1' My DrillDown is not working. can any one please helpme on this how can I get the working DrillDown as my Dimension.
Here one Dimension is fiscalyear-Periodnum another one is ManagerDrillDownGroup, if I clik on any bar I am not getting specific manager s subordinates, instead of that I am getting all the subordinates.
Regards
John