8 Replies Latest reply: Jul 11, 2017 11:33 AM by SOWJANYA MOOLA RSS

    Set Analysis: Rolling Months & 2nd condition

    Simon Goodman

      I am running a test to create rolling 12 months using set analysis. I have attached an example. Pivot table 1 uses the following expression but does not work. I think it is something so obvious I am blind to it.

       

      Sum({=$(=Date(addmonths(Max(MonthYr), -12, 'MMM-YY')) <=$(=Date(addmonths(Max(MonthYr), 0,  'MMM-YY'))"} >} Points)

       

      I then want to add a second set analysis condition into it, found in pivot table 3. Is this possible? I would be grateful for some help. Manny thanks.