I would like to sort a pivot table by one catagory within different groups. ie

Group / Sub group / Data
A 1 100
2 200
3 300
B
1 300
2 200
3 100

How do I get group "B" to sort in an order other than the same order as
group "A".
It seems that the pivot table will only let me sort one group of data?

Thanks so much for your help on this,

Eric