CODEWITHSUNDEEP
excelpivotpivot-table
David542
David542

Reputation: 110093

Sorting in excel within a pivot value

In excel, sorting by the Row/Column labels allow you sort by the "Total" amount for that metric. For example, if I want to sort by the "Grand Total" SUM in USD, I can do:

enter image description here

How would I sort within a particular value of a column? For example, if I wanted to get Sum of Sales in usd in the "US" column --

enter image description here

Is there a way to sort by values within a particular column?

Upvotes: 0

Views: 403

Answers (1)

Georgina Skibinski
Georgina Skibinski

Reputation: 13377

You have to right click where the content of the column you want to sort is.

Then Sort > Sort Smallest to Largest/Largest to Smallest

I'm using Excel from MS Office 2013.

Upvotes: 1

Related Questions