
Contributor II
2020-01-27
10:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Cumulative percentage of total
Hi, I'm trying to create a Pivot table showing the cumulative percentage of the 'base', like the pivot in green below. Any ideas?
- Tags:
- pivot tables
1,925 Views
1 Reply

Creator II
2020-01-27
11:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use the following as the measure:
rangesum(above(total sum(Orders), 0, rowno(Total))) / sum(Total Orders)
Hope it helps!
