topic Show/Hide Subtotal in Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Show-Hide-Subtotal-in-Pivot-Table/m-p/344144#M574750 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Duplicate the table and add a button "Show/Hide Subtotal" </P><P>Add a trigger on the button which change a variable. Use this variable to show or not the table with subtotal</P><P></P><P>Hope that helps</P></BODY></HTML> Fri, 08 Jun 2012 11:29:25 GMT 2012-06-08T11:29:25Z Show/Hide Subtotal in Pivot Table https://community.qlik.com/t5/QlikView/Show-Hide-Subtotal-in-Pivot-Table/m-p/344143#M574749 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>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?</P><P></P><P>Thanks in advance.</P><P></P><P>Regards,</P></BODY></HTML> Fri, 08 Jun 2012 11:17:02 GMT https://community.qlik.com/t5/QlikView/Show-Hide-Subtotal-in-Pivot-Table/m-p/344143#M574749 2012-06-08T11:17:02Z Show/Hide Subtotal in Pivot Table https://community.qlik.com/t5/QlikView/Show-Hide-Subtotal-in-Pivot-Table/m-p/344144#M574750 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Duplicate the table and add a button "Show/Hide Subtotal" </P><P>Add a trigger on the button which change a variable. Use this variable to show or not the table with subtotal</P><P></P><P>Hope that helps</P></BODY></HTML> Fri, 08 Jun 2012 11:29:25 GMT https://community.qlik.com/t5/QlikView/Show-Hide-Subtotal-in-Pivot-Table/m-p/344144#M574750 2012-06-08T11:29:25Z Show/Hide Subtotal in Pivot Table https://community.qlik.com/t5/QlikView/Show-Hide-Subtotal-in-Pivot-Table/m-p/344145#M574751 <HTML><HEAD></HEAD><BODY><P> 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.</P><P></P><P>Regards,</P></BODY></HTML> Fri, 08 Jun 2012 12:22:22 GMT https://community.qlik.com/t5/QlikView/Show-Hide-Subtotal-in-Pivot-Table/m-p/344145#M574751 2012-06-08T12:22:22Z Re: Show/Hide Subtotal in Pivot Table https://community.qlik.com/t5/QlikView/Show-Hide-Subtotal-in-Pivot-Table/m-p/344146#M574752 <HTML><HEAD></HEAD><BODY><P>Done!</P></BODY></HTML> Fri, 08 Jun 2012 12:55:21 GMT https://community.qlik.com/t5/QlikView/Show-Hide-Subtotal-in-Pivot-Table/m-p/344146#M574752 2012-06-08T12:55:21Z