Diagnosis
In attempting to calculate the subtotals, you sorted the column with thecriterion and the column with the calculation of totals. The sortsequence is incorrect: the numeric column must not be sorted before thecriteria column.

Procedure
Change the sort sequence.