I have a Pivot table with values for over 30 colomns of data. As the default setting for numbers is to count the data and I need to average it I am changing each of these coloms using the value field setting option.
Is there any way I can change all of the coloms in one go? I have tried selecting data across the colomds and right clicking to value field setting but it only changes the first colomn.
Hi and weclcome to the board.
There doesn't seem to be any way to do this, but this add-in will help you out
Cheers
Wow, that is great!!! Thank you for your help and quick response!
You're welcome and thx for the feedback
bug in Add-In
The here described Add-in is a great improvement but in PIVOT/Data Fields, after using AVERAGE All the name of the summary does not change anymore from "Avg of". When chosing "SUM All" after AVERAGE All was used before, the values in the body change from average to totals but NOT the summary name which stays "Avg of....". Any way to get rid of this bug?
I tried the add in it didn't let me change values to be able to show then as a percentage of the grand total of the row!
Any other ideas?
Vgr,
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks