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.
