Rolling Periods Issue!!

[#1]

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