refer to below sample.
I do a subtotal on column ID1, then subtotal again on ID2.
the result looks weird:
row 11 shows b total and row 12 shows y total, it should be the other way
round.
same apply to row 16 (c total) and row 17 (y total) etc.

pls advice. thanks !

ID1 ID2 amt
a x 1
b x 2
b x 3
b x 4
b y 5
b y 6
c x 7
c y 8
d x 9
d y 10