5 Replies Latest reply: Nov 3, 2017 11:30 PM by Shraddha Gajare RSS

    Dynamic 'previous month' Selctions in Set Analysis

    Rishi Minawala

      Hi

       

      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!