I can't sort the aggregates of the following pivot table:
a = { {"Grupo5", 1, 2, 3}, {"Grupo1", 4, 5, 6}, {"Grupo5", 7, 6,
7}, {"Grupo2", 8, 9, 10}, {"Grupo2", 8, 9, 10} };
SortBy[
PivotTable[
Sort[ Tabular[ a , {"grupo", "num 1", "num 2", "num 3"} ] ],
Length[\.08 #["num 1"]] &, "grupo", "num 2",
IncludeGroupAggregates -> True],
#[[1]] &
]
Attachments:
