Show/Hide Subtotal in Pivot Table

[#1]

Hello,

I am using a pivot table for report with10 columns in dimensions. At present I am showing subtotal for Columns 1 to 5. When user view report in Internet Explorer they need to have an option to show or hide sub total for columns they want. Is that thing possible using script or macro where user can turn on / off display partial total?

Thanks in advance.

Regards,

[#2]

Hi

Duplicate the table and add a button "Show/Hide Subtotal"

Add a trigger on the button which change a variable. Use this variable to show or not the table with subtotal

Hope that helps

[#3]

Thanks for the quick response. I am not so much familiar with using trigger. I would appreciate if you can send me sample or script I need to add in macro.

Regards,

[#4]

Done!