Pivot Table - adding a new field
 

I've a column in a pivottable as 'running total'. I want to add another
column 'percent' (not from the data in the source) which will give me
percentage of the 'running total' column. That is, for instance:

running total percentage
12 34.3%
24 68.6%
35 100.0%

Thanks.

http://www.contextures.com/xlPivot10.html

there are instructions for running total

--
Regards,

Peo Sjoblom

(No private emails please)


"Pivot Table" <Pivot wrote in message
...
I've a column in a pivottable as 'running total'. I want to add another
column 'percent' (not from the data in the source) which will give me
percentage of the 'running total' column. That is, for instance:

running total percentage
12 34.3%
24 68.6%
35 100.0%

Thanks.

If your pivot table remains the same physical size when you refresh, you
could just add formulas to the right of the pivot table (based on the pt data
and not the source data)

"Pivot Table" wrote:

I've a column in a pivottable as 'running total'. I want to add another
column 'percent' (not from the data in the source) which will give me
percentage of the 'running total' column. That is, for instance:

running total percentage
12 34.3%
24 68.6%
35 100.0%

Thanks.