When you assign multiple columns to a group in an summarize table or pivot table, clicking the value column header to sort may not change the order.
This occurs because sorting is applied only within groups. You can resolve this by specifying “Across groups” in the sort application scope from the settings.
This allows you to sort values across groups.
