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

[Deleted]

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,

Michaela