Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculated field - Pivot Table
Is it possible to add a calculated field into a Pivot Table where the Calced
field is a percentage of the subtotal for a column. For column A, I have five values; four of these values are subtotaled to equal 20: A 2 5 4 9 _ 20 12 _ 32 How do I add a calculated field (or item) which will show 2/20=10%, 5/20=25%,...and finally 12/32=37.5% thank you Matt |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculated field - Pivot Table
You can't divide by a subtotal amount in a pivot table. By arranging the
fields differently you may be able to use the % of column or % of row custom calculation. Or, perform the calculations outside of the pivot table, using the GetPivotData function to extract the data. Matt M HMS wrote: Is it possible to add a calculated field into a Pivot Table where the Calced field is a percentage of the subtotal for a column. For column A, I have five values; four of these values are subtotaled to equal 20: A 2 5 4 9 _ 20 12 _ 32 How do I add a calculated field (or item) which will show 2/20=10%, 5/20=25%,...and finally 12/32=37.5% thank you Matt -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculated field in Pivot Table | Excel Discussion (Misc queries) | |||
calculated field in a pivot table? | Excel Discussion (Misc queries) | |||
Using a MIN, MAX formula on a calculated field in a pivot table | Excel Discussion (Misc queries) | |||
Pivot table page field switch to (all) if my criteria is not avail | Excel Discussion (Misc queries) | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) |