Alternate to Sorting Pivot table values when you have multiple columns in the Row area

Published: 28 February 2017
on channel: Kunaal Naik | Data Science Masterminds
13,968
49

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.