If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"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
|
|||
|
|||
"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 |
Thread Tools | |
Display Modes | |
|
|