2 Replies Latest reply: Jul 14, 2017 10:03 AM by Phil Speight RSS

    Set Analysis Previous Month

    Phil Speight

      Hi

       

      Could someone give me an example of how to get the previous month's data only in set analysis for PK_Date.

       

      I am currently using the below as a dimension, which returns previous month (then I suppress Null).

       

      I know it would be better to make it an expression.Any help appreciated.  My dimension formula is:

       

      MonthName(MonthStart(Today())-1)=(MonthName(PK_Date)),(MonthName(PK_Date))

       

      How do I make it a set analysis? or is there a better way?

       

      n.b.  PK_Date is month level only

       

      Cheers

       

       

       

      Phil