2 Replies Latest reply: Jul 31, 2015 5:53 AM by Jonathan Dienst RSS

    Help with Set analysis

      Hi,

       

      My requirement is to get records of previous year when a particulat year is selected .

       

      Sum of Sales

       

      For the same,  I have written the following code

       

      sum({<CurrYear={$(=CurrYear-1)} >}Sales).

      So if Curryear is selected as 2015 then i should sum up 2014 records. The formula is working fine when a particular year is selected.

      BUt I have a chart where my Curryear is the dimension and my above formula is failing and returning 0.

      Chart is Bar chart and the dimension is Curryear (2013,2014,2015, etc). For all years it is showing as 0

      Can any one help on this problem? I think we need to change the set analysis, CurrYear = ???

       

       

      BR,

      Neehu