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

    compare each month to the same month last year?

    Minh-Tri TRUONG

      Hello,

       

      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!