Creating subtotals within a pivot table

[#1]

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.

[Anonymous]

James

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

[#3]

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.

[Anonymous]

James

Did you tick it on Manufactured?

Best Regards,     Bill