6 Replies Latest reply: Aug 2, 2016 6:57 AM by Sunny Talwar RSS

    Comparing YearMonth to Previous Year.

    Sam Maile

      Hi,

       

      I've created a set analysis to display the current 'selected' YearMonth (Current dimension) this is a date format YYYY/MM within the current DB field:

       

      The analysis to calculate where sales total > 0 = COUNT({$<SALES_TOTAL={">0"}>}  SALES_TOTAL)


      This will show the selected 'YearMonth' and the sales total for that specific month with sales > 0.

      The YearMonth looks like " 2016/07 " which is an existing field.

       

      I need to create an expression where the sales total >0 (as shown above) with the YEARMONTH (currently selected) - 12 months?

       

      So, I am having problems trying to compare in a KPI last years figure.

       

      Many thanks.