3 Replies Latest reply: Oct 6, 2016 12:26 PM by Sunny Talwar RSS

    Set analysis - year -1 for all selections

    Dana Rozenblum

      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).

       

      Thanks!