Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
caluclated field in pivot table? | Excel Worksheet Functions | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
Adding a formula to a pivot table | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) |