Fix Sub row label instead of using Sort by Ascending or Descending

Hi All,

Will like to check how can i sort by Sub group of the pivot table to show accoring to what i want?
Like for example instead of Ascending or Descending, it will sort by the sub group that i set.

Example:

SoftDrink:
7-up
100 plus
Coca Cola

Hot Drink:
Coffee
Tea

Fruit Jucie:
Apple
Pear
Orange
Mango


Instead of sort by Ascending order


Hot Drink:
Coffee
Tea

Fruit Jucie:
Apple
Pear
Orange
Mango

SoftDrink:
7-up
100 plus
Coca Cola



Thanks in Advance.

My report always refresh every time when the user open the file or refresh the data.
Sometime the Sub group can be different.
Sometime will be shorter, sometime will be longer.

Hi All,

I managed to get what i needed.
I just go to the Sub group and right click, move the sub group up or down.

Thanks