20 Replies Latest reply: Jun 28, 2016 9:42 AM by Sunny Talwar RSS

    Showing previous months sales - Set Analysis.

    Sam Maile

      Hi there,


      Trying to get my previous sales from last month subtracted from the current sales this month, so it shows the amount of sales (less or more) than the previous.


      My current set analysis:

       

      Count({<Month={">=$(=MonthStart(AddMonths(Max(Month),-1))) $(=MonthStart(AddMonths(Max(Month),0)))"}>}Sales_total)


      This giving the wrong result, obviously. Not too sure how to structure my analysis. Any assistance would help.


      Thanks.