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.
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.