Number grouped rows

source result
Group Category Sales Group Category Sales Index
Food Breakfast
99,562.64
Alcohol Wine
217492.74
1
Food Soups/Salads
113,642.33
Alcohol Draft Beer
132882.83
2
Food Sandwiches
217,510.36
Alcohol Liquor
50939.94
3
Food Entrees
290,278.36
Alcohol Canned Beer
49996.55
4
Food Non Alc Beverage
93,580.81
Alcohol Bottled Beer
29043.99
5
Food Appetizers
98,191.52
Alcohol Coolers/Ciders
22628.14
6
Alcohol Draft Beer
132,882.83
Alcohol Liquor Modifiers
9.3
7
Food Burgers
138,000.37
Food Entrees
290278.36
1
Food Desserts
16,039.30
Food Sandwiches
217510.36
2
Alcohol Wine
217,492.74
Food Burgers
138000.37
3
Alcohol Bottled Beer
29,043.99
Food Soups/Salads
113642.33
4
Alcohol Liquor
50,939.94
Food Breakfast
99562.64
5
Alcohol Coolers/Ciders
22,628.14
Food Appetizers
98191.52
6
Alcohol Canned Beer
49,996.55
Food Non Alc Beverage
93580.81
7
Alcohol Liquor Modifiers
9.30
Food Desserts
16039.3
8
Food Cakes
234.55
 Food Cakes
234.55
9


Code:
let
    Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
    Type = Table.TransformColumnTypes(Source,{{"Group", type text}, {"Category", type text}, {"Sales", type number}}),
    Sort = Table.Sort(Type,{{"Group", Order.Ascending}, {"Sales", Order.Descending}}),
    Group = Table.Group(Sort, {"Group"}, {{"Data", each _, type table}}),
    InnerIndex = Table.AddColumn(Group, "Partitioned", each Table.AddIndexColumn([Data], "Index", 1, 1)),
    RC = Table.RemoveColumns(InnerIndex,{"Data"}),
    Expand = Table.ExpandTableColumn(RC, "Partitioned", {"Category", "Sales", "Index"}, {"Category", "Sales", "Index"})
in
    Expand