3 Replies Latest reply: Sep 29, 2017 10:35 AM by Sunny Talwar RSS

    Year over Year pace

    Scott Wisker

      I'm trying to create a chart similar to the following

      Example 01.png

       

      where Daily Billing is the incoming for that day, Cumulative Current is the running total of the Daily Billing, and % LY is the Current Cumulative compared with last year. The cumulative of last year does not need to be shown, only the % LY.

       

      So far no combination of RangeSum or other aggregation has been effective.  I have attached the sample data of three customers from 4/1/16 through 9/25/17. The fiscal year begins on 4/1 so the accumulation from last year should begin at 4/1/16 and current year should begin at 4/1/17.