5 Replies Latest reply: Nov 3, 2017 11:30 PM by Shraddha Gajare 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!