Pivot table question: Sorting the subgroup in a pivot table (whenusing the top 10 option for the sub

[Mike C]

Hello:
I have created a pivot table which has a one subgroup in the second
column from the left. It uses the Top 10 option, so there are 10
subgroups

So my data looks something like this:

Group 1 50
Subgroup 1a 10
Subgroup 1b 40
Eight more subgroups

Group 2 30
Subgroup 2a 20
Subgroup 2b 10
Eight more subgroups

What I would like to do is sort by THe totals for Group 1, but then
also sort by the subgroups, based on the values for each subgroup
(similar to the "Sort by, then by.." option in a normal table).

So, the top 10 Groups will show up at the top, and then the subgroups
will also be sorted descending.

Does anyone know how I can accomplish this?

Thanks for any suggestions