I'm working in Excel 2013.
The set up:
I have a pivot table with 48 columns of data and I want to set the default VALUE to MIN or MAX or AVERAGE. I see how I can set each column individually in the VALUES field or I can right-click on a column and select SUMMARIZE VALUES BY and do each column individually.
My question:
Is there an easier way to select all columns and set the VALUE to my desired condition??
Thanks!
-Troy
Bookmarks