| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set calculation type for all value fields in a pivot table at once
I know that a pivot table value field calculation defaults to sum or count
depending on the contents and whether there are any blank cells. What I want to do is set all the values to calculate by sum - is there a shorter way of doing it than right-clicking every value field in turn? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When refreshing pivot tables my pivot table chart type changes | Excel Discussion (Misc queries) | |||
| Pivot table fields | Excel Discussion (Misc queries) | |||
| Pivot Table Calculation Fields | Excel Discussion (Misc queries) | |||
| number of fields in the row fields in pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table Fields | Excel Worksheet Functions | |||
Linear Mode
