Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Global" change Pivot Value field settings
Other than a macro, is there a simple way to change the value field settings
for an entire pivot table at once? I want to flip the report from sum to average to count across all 40 Value columns - it's a little laborious a column at a time. -- Mike Watkins |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"Global" change Pivot Value field settings
There's no setting that you can change manually, to use a different
summary function in all the data fields. If you can use macros, there's a data field reset command in the pivot table add-in he http://www.contextures.com/xlPivotAddIn02.html watkincm wrote: Other than a macro, is there a simple way to change the value field settings for an entire pivot table at once? I want to flip the report from sum to average to count across all 40 Value columns - it's a little laborious a column at a time. -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change default settings of "Save external links values" | Excel Discussion (Misc queries) | |||
Pivot tables - how do I change default from "count of" to "sum of" | Excel Worksheet Functions | |||
How do I stop "global" hyperlinks changing to "local" links? | Excel Worksheet Functions | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Pivot Tables - How can I "reset" the selections in "Row Field"? | Excel Discussion (Misc queries) |