| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table Average with [h]:mm format
Is there a way to get the correct average in the Total Row or Column in a
Pivot table when the value field is formatted with [h]:mm? The average works find in normal number format, but gives the Total rather then the average when formatted with [h]:mm. Using Excel 2007. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average of % in pivot table | Excel Discussion (Misc queries) | |||
| Average in Pivot Table | New Users to Excel | |||
| Average in a Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot table average | Excel Discussion (Misc queries) | |||
| How to Get Sum of the Average in Pivot Table? | Excel Discussion (Misc queries) | |||
Threaded Mode
