PDA

View Full Version : VBA to record the field settings of a pivot



kevvukeka
03-28-2013, 07:32 AM
Hi All,

I am beginner to VBA. I need some help with Pivots. I have few pivots, for which I need to show the data as % of grand total.Every time I add a new item to the pivot, i need to modify the value setting to show counts as % of grand total. I have around 15 countries and with 20 pivots in each.

Can someone help with some VBA code that could modify the field setting of all the pivots in the sheet to "show as % of grand total"?

Thanks & Regards,
Praveen