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
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
Wow, that is great!!! Thank you for your help and quick response!
You're welcome and thx for the feedback
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks