7 Replies Latest reply: Nov 23, 2017 6:51 AM by Rishi Minawala RSS

    Dynamic 'previous month' Selctions in Set Analysis

    Rishi Minawala



      I have a KPI number where I want to basically show the current month amount and the previous month amount, based on the month a user selects. Current month works fine using:


      sum({<Month={$(=MaxString(Month))} >}Amount)


      I cannot get the previous month when simply including the '-1' or am I missing something obvious.


      Any help would be great!


      Thanks in advance!