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

    Help with Set analysis



      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 = ???