| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Calculated Field in Pivot Table
Hi
I have a pivot set up as below Page Heading - Division Row Heading - Contract Status (A,B,C) Column Heading - Suppliers The pivot summarise total spend by contract status. I have added a formula at the bottom of the pivot table which works out the % of spend per Contract status. This works until someone filters the pivot and then as the cell references move my formula fails with the #Div/0! error. Is there another way of acheiving this result - maybe using a calculated field in pivot? TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Customize functions in the Data Field | Excel Discussion (Misc queries) | |||
| Setting default pivot table field setting to "sum" | Excel Discussion (Misc queries) | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
| Pivot table field names | Excel Worksheet Functions | |||
| Summarize by "Median" in the Pivot Table Field for Excel | Excel Worksheet Functions | |||
Linear Mode
