3 Replies Latest reply: Jun 8, 2012 8:55 AM by adgalelt RSS

    Show/Hide Subtotal in Pivot Table



      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.