1 2 Previous Next 19 Replies Latest reply on Apr 24, 2018 12:23 PM by Lauren Brown

    Rolling 12 months forwards and backwards - different order start dates

    Lauren Brown

      I have attached sample data in a workbook with accounts that all have sales of two item codes.

       

      What I am trying to do is show rolling 12 month sales from the start date of the when the customer started buying "ITEM B." In addition, show rolling 12 month sales prior to the date the customer starting buying "ITEMB," of "ITEMA" sales.  The challenge here is that each customer has a different start date of when they starting buying "ITEMB."

       

      Here is what I have tried and have not been successful:

       

      Moving table calculation but it only works when I am filtered on one account number

      Fixed calculation

      Date Diff calculation

      Calculation with a reference date

       

      Any insight would be greatly appreciated!

        1 2 Previous Next