Alternate to Sorting Pivot table values when you have multiple columns in the Row area
It is not possible to sort all the values in a pivot table when we have multiple columns in the Row area. We can only sort the values based on each of the categories.
If we want to sort the values based on the values irrespective of the order of the categories, we need to use a combination of Remove Duplicates and SUMIFS.