| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
custom calculation in Mutiple consolidation pivot table
I am trying to do get an average total from a multiple consolidation pivot
table. When I go to the field settings and select average I get this error: "Averages, standard deviation are not supported when a pivot table report has calculated items." Does anyone know how to I can get my averages to show instead of a sum? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| % of subtotal custom calculation in a pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table-Multiple Consolidation Ranges | Excel Discussion (Misc queries) | |||
| how can i do mutiple sort in pivot table | Excel Discussion (Misc queries) | |||
| Pivot table - Custom calculation question | Excel Worksheet Functions | |||
| How to use mutiple spreadsheets in a pivot table? | Excel Discussion (Misc queries) | |||
Linear Mode
