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

    Set Analysis Previous Month

    Phil Speight



      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:




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


      n.b.  PK_Date is month level only