Excel Switch All Pivot Value Fields To Average or Max 2498

nnnn

Microsoft Excel Tips and Tricks

nJeremy asks Is there a way to select multiple headings and change all of their “Summarize value field by” at once? I have hundreds of headings, each time I want to change their value by Max, Min, Average, I have to select one heading at a time, it is extremely labor intensive. Is there a way to change field calculation for multiple headings at once?nnnn

Credit MrExcel.com

n

Leave a Reply

Your email address will not be published. Required fields are marked *