I created a pivot table and want to change the value field settings for mulitple cells without having to change one one by one. I have right clicked and went to field settings and made the change, but it only changed from 'count' to 'sum' for one of the 'Source Name'. Is there a way that I can change all of the fields from 'count' to 'sum' for all of the 'Source Name's' without having to choose each one? Also, how can I copy and paste a print screen in this thread? Using a copy and paste of the print screen would be much easier than explaining the problem.
Bookmarks