How do I add a cumulative total to a pivot table in Excel? It would save me hours, but I just can’t figure it out. Google tells me that there are others looking for the same solution, but the answer does not appear to be out there.

The goal is to have a pivot table showing customers, revenue, and cumulative revenue. A quick glance at the chart would show me how many customers make up the top 80% of revenue, for instance.

Help!

Update: Thanks, Alasdair.   Run a pivot table, right-click on the data field, select Field Settings, Options, Show Data As “Running Total In” and then choose the subcategory level.

If you want to show a running percentage, simply add a column in the raw data to give “% of total”.  Use a SUMIF to calculate each row’s data as a percentage of the total.  In the pivot, use the “% of total” and choose Show Data as “Running Total In” again.