MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Percent of Running Total in Pivot Table


Posted by Julie on January 22, 2002 12:45 PM

Does anyone know how to get a percent of a running total in a pivot table?

For example

Month Total Running Total Percent
1 10 10 33%
2 5 15 50%
3 15 30 100%

Any help is greatly appreciated.


Posted by Mark W. on January 22, 2002 12:56 PM

Why not add a '% of Total' field to your data list
using the formula, =Total/SUM(Total)? Next,
include this '% of Total' in your PivotTable using
the "Running Total in" option (like you did for
your Total field) and then format it as 0%. Be
sure to Enable selection before applying this
format so that it will persist after Refresh.