3 Replies Latest reply: Apr 2, 2016 10:23 AM by Sangram Reddy RSS

    compare each month to the same month last year?



      I have a pretty basic table and I need to compare the turnover of each month vs the same month last year :

      - Date

      - Day

      - Month

      - Year

      - Turnover


      Something like

      =Sum(Turnover) /  Sum( {Day=, Month=SameMonthAsTheleftPart,YearMonth=YearFromTheLeftPart - 1>} Turnover)


      Is it possible?


      I hope you can help.


      Many thanks!