topic Question about Show Partial Sums in pivot table in QlikView https://community.qlik.com/t5/QlikView/Question-about-Show-Partial-Sums-in-pivot-table/m-p/192236#M53977 <HTML><HEAD></HEAD><BODY><P>I am using a pivot table with 'show partial sums' on the Brand/Generic column (column 2):</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-3413_sourceID:3413" /></P><P>However, I really need the Price Term values sub-totaled within the 'Combined' section like this:</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-3414_sourceID:3414" /></P><P>Any suggestions on how to accomplish this? I'm guessing 'show partial sums' isn't going to be sufficient.</P></BODY></HTML> Fri, 28 Jan 2011 18:13:12 GMT 2011-01-28T18:13:12Z Question about Show Partial Sums in pivot table https://community.qlik.com/t5/QlikView/Question-about-Show-Partial-Sums-in-pivot-table/m-p/192236#M53977 <HTML><HEAD></HEAD><BODY><P>I am using a pivot table with 'show partial sums' on the Brand/Generic column (column 2):</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-3413_sourceID:3413" /></P><P>However, I really need the Price Term values sub-totaled within the 'Combined' section like this:</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-3414_sourceID:3414" /></P><P>Any suggestions on how to accomplish this? I'm guessing 'show partial sums' isn't going to be sufficient.</P></BODY></HTML> Fri, 28 Jan 2011 18:13:12 GMT https://community.qlik.com/t5/QlikView/Question-about-Show-Partial-Sums-in-pivot-table/m-p/192236#M53977 2011-01-28T18:13:12Z Question about Show Partial Sums in pivot table https://community.qlik.com/t5/QlikView/Question-about-Show-Partial-Sums-in-pivot-table/m-p/192237#M53978 <HTML><HEAD></HEAD><BODY><P>Did you try enabling Partial Sums for Brand/Gen column and Price Term Column.</P></BODY></HTML> Sat, 29 Jan 2011 12:17:29 GMT https://community.qlik.com/t5/QlikView/Question-about-Show-Partial-Sums-in-pivot-table/m-p/192237#M53978 2011-01-29T12:17:29Z Question about Show Partial Sums in pivot table https://community.qlik.com/t5/QlikView/Question-about-Show-Partial-Sums-in-pivot-table/m-p/192238#M53979 <HTML><HEAD></HEAD><BODY><P>Yes, the top screen cap is the result of having both of them enabled. Is my only solution going to be two sheet objects? I sure hope I'm wrong. It's not the most end-user friendly...</P></BODY></HTML> Mon, 31 Jan 2011 02:29:18 GMT https://community.qlik.com/t5/QlikView/Question-about-Show-Partial-Sums-in-pivot-table/m-p/192238#M53979 2011-01-31T02:29:18Z