Excel pivot table sort by values

I've done quite a bit of searching but cant find working instructions on how to sort a pivot table in Excel by a field that has been placed in the Values area.

The best I've been able to come up with is to copy and paste values to another worksheet and do the sort on the flat data set.

But, it seems there must be a way to sort by Values field within the pivot table. Does anyone know how to do this?

1 Answer

To sort by Values in a PivotTable, right-click on one Value cell, hover over Sort, and click the type of sort to perform.

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy