Hi there,

I have seen a few posts on this topic, but i cant seem to find one that will work when applyig filters to the data. 

I have Rows and Data in a pivot view

I want to show the running total of revenue as a % of the total for the data set.  

If i add a filter, i want the running total to update based on the filtered data.

Rows:

Product Code

Data:

Revenue

I want to show:

Product            Revenue        Running Total          % of total

product1            10                        10                          50%

product2            5                          15                          75%

product2            5                          20                          100%