CODEWITHSUNDEEP
excelpivot-table
egg
egg

Reputation: 373

How to sort PivotTable by a specific column?

I have a PivotTable that is structured as follows:

ROWS> article numbers
COLS> week dates
VALUES > sales amount

I want to sort the article numbers by the largest sales in the last(latest) week number. But I have no idea how to do this. The default sort options only allow sorting the Grand Total, which doesn't help.

Any ideas?

Upvotes: 1

Views: 20628

Answers (1)

agold
agold

Reputation: 6276

Like you said, by default Excel sorts by Grand Total, but you can change this. First go to the More Sort Options... menu:

Pivot Table menu

Then select in the sort options to sort ascending or descending by the sales amount (in my example sum of sales). Then click on More Options...:

More Sort Options

Now you can should select Values in selected column. You'll see that it refers to the first row of the Grand Total column (in my example this was $E$5), now change this to your last week's column (in my example $D$5).

Upvotes: 3

Related Questions