0 Replies Latest reply: Oct 5, 2016 3:53 AM by Dana Rozenblum RSS

    Set analysis - year -1 for all selections

      Hi All,


      I'm trying to reach the following result with set analyais:


      For each year year chosen (not max year) show data for previous year. So:

      If 2015 is chosen - show data for 2014.

      If 2015 and 2016 are chosen show data for 2014 and and 2015.

      If none is selected (so all the years are chosen by default) - show data for year-1 of all the years.


      How can that be done?

      (The needed solution is more complex but that would be a good start).