
Contributor II
2017-12-11
09:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Count previous column measure in a Pivot Table
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
1,508 Views
3 Replies

Partner - Champion III
2017-12-12
02:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:


Creator III
2017-12-12
02:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You have Column() function.
Use Column(1) + Sum(Value)
It will add the previous column value with the sum(value)

Contributor II
2017-12-12
02:56 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This helped immensely. Thanks and bunch!
