| 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 |
| 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) | |||
Threaded Mode
