Pivot Table - adding a new field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

pivot table excel 2
How to add a percentage column in a Pivot Table 1
Pivot Table percentages 1
How do I perform extended calculations in a Pivot Table in Excel 2 4
Pivot table problem 4
Pivot tables % of subtotal 1
Curve fitting with weighted trendline 1
Pivot Table - Calculated Field - Percentage - Rept 2

Back
Top