Change value field settings - "Show values as" for multiple columns in pivot table

Not applicable

Dear all, 


I am struggling with changing the "Show values as" settings for multiple columns in pivot table (e.g. from % of total to % of culumn total) - it takes ages to change the setting for 20 columns. Is there any macro which would allow me to change the settings for all columns at a time?  I know there is one for the "Summarize values by" setting, so maybe there is one for this case as well. 


Thanks for help,


Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies