Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to create a chart similar to the following
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.
Try now.... it seems that you are not using QV12 or above and that is by sorting within the aggr() function did not work...
May be like attached?
Yes, but the chart does not work when I open your file.
Try now.... it seems that you are not using QV12 or above and that is by sorting within the aggr() function did not work...