topic Re: Creating subtotals within a pivot table in QlikView

Creating subtotals within a pivot table

Fri, 29 Nov 2013 11:13:20 GMT

Hi all

For the Pivot table below I am looking to create sub totals for the Category field based on the selections in the red boxes (i.e. a sub total for Blend Milk Based, Goldstart, and SureStart. A further sub total for EasiStart/Milkiwean, MultiStart, and Vital etc). I am new to Qlikview and do not have much developing experience and would really appreciate any help that you can provide.

Re: Creating subtotals within a pivot table

Anonymous — Fri, 29 Nov 2013 11:20:34 GMT

James

On your Pivot Table's, Presentation tab for the corresponding expressions tick Show Partial Sums.

Re: Creating subtotals within a pivot table

Fri, 29 Nov 2013 11:31:23 GMT

Hi Bill

Ticking Show Partial Sums only shows me the sub total for each value within a field. I am looking to show a sub total for a grouping of values with a field. So looking at my pivot table I am looking to show sub totals within the Category field. The first sub total would be for the values Blend Milk Based, Goldstart, and SureStart.

Re: Creating subtotals within a pivot table

Anonymous — Fri, 29 Nov 2013 11:34:42 GMT

James

Did you tick it on Manufactured?

Best Regards, Bill