topic Pivot Table Partial Sums Help in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-Partial-Sums-Help/m-p/588652#M218298 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a pivot table with dimensions Agency, Client, Parent, Network, Buy Type and Year. I have expressions for Total Spent and Year over Year. After each client, I want to show a row that has total spent for that client and year over year change. I tried to implement this by checking 'Show Partial Sums' in the Presentation tab of the table, but that shows one row at the end for all the clients whereas I want a row after each client.</P><P></P><P>Any help? I've the portion of my application with fields scrambled to help illustrate my dilemma. Let me know if you need further elaboration.</P><P></P><P>Thanks and best,</P><P>Ryan</P></BODY></HTML> Tue, 01 Apr 2014 18:39:13 GMT 2014-04-01T18:39:13Z Pivot Table Partial Sums Help https://community.qlik.com/t5/QlikView/Pivot-Table-Partial-Sums-Help/m-p/588652#M218298 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a pivot table with dimensions Agency, Client, Parent, Network, Buy Type and Year. I have expressions for Total Spent and Year over Year. After each client, I want to show a row that has total spent for that client and year over year change. I tried to implement this by checking 'Show Partial Sums' in the Presentation tab of the table, but that shows one row at the end for all the clients whereas I want a row after each client.</P><P></P><P>Any help? I've the portion of my application with fields scrambled to help illustrate my dilemma. Let me know if you need further elaboration.</P><P></P><P>Thanks and best,</P><P>Ryan</P></BODY></HTML> Tue, 01 Apr 2014 18:39:13 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Partial-Sums-Help/m-p/588652#M218298 2014-04-01T18:39:13Z Re: Pivot Table Partial Sums Help https://community.qlik.com/t5/QlikView/Pivot-Table-Partial-Sums-Help/m-p/588653#M218299 <HTML><HEAD></HEAD><BODY><P>I think you need to enable the partial sum on presentation tab for parent level (summing all parents grouped by Client).</P></BODY></HTML> Tue, 01 Apr 2014 18:44:52 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Partial-Sums-Help/m-p/588653#M218299 swuehl 2014-04-01T18:44:52Z Re: Pivot Table Partial Sums Help https://community.qlik.com/t5/QlikView/Pivot-Table-Partial-Sums-Help/m-p/588654#M218300 <HTML><HEAD></HEAD><BODY><P>yes, thank you.</P></BODY></HTML> Tue, 01 Apr 2014 18:55:06 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Partial-Sums-Help/m-p/588654#M218300 2014-04-01T18:55:06Z