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

    Comparing YearMonth to Previous Year.



      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.