Sorting in excel within a pivot value

Question

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:

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 --

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

You should be able to do the same for the US column. I'm using windows but I think the process would be similar, just right click a value within the US column and select sort. — Terry W
– Terry W, Commented Sep 12, 2019 at 4:43

Georgina Skibinski · Accepted Answer · 2019-09-12 04:43:49Z

1

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.

answered Sep 12, 2019 at 4:43

Georgina Skibinski

13.5k2 gold badges16 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sorting in excel within a pivot value

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related