Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!, I'm looking to count the totals of columns by including the previous weeks data as well in a pivot table. Current data looks like this:
Date2 | |||
---|---|---|---|
Date1 | 02/10/2017 | 09/10/2017 | 23/10/2017 |
02/10/2017 | 30 | 2 | 9 |
09/10/2017 | 15 | 7 | |
23/10/2017 | 10 |
I want it to look like the following, where it is adding the previous column as well for a running total so to speak:
Date2 | |||
---|---|---|---|
Date1 | 02/10/2017 | 09/10/2017 | 23/10/2017 |
02/10/2017 | 30 | 32 | 41 |
09/10/2017 | 15 | 22 | |
23/10/2017 | 10 |
would someone be able to point me in the right direction for this?
Cheers
You have the Before () inter-record chart functions (and it's siblings).
Before ( Sum (Qty) ) +Sum (Qty) )
Is an example on how you can keep a running total column-wise.
Here is the documentation and further examples:
You have Column() function.
Use Column(1) + Sum(Value)
It will add the previous column value with the sum(value)
This helped immensely. Thanks and bunch!