Sort by count in pivot table

Question

Hello,

I created a pivot table to get the count of each time the thing in the left column appears in my data.

I can sort the left column A-Z with the dropdown.

But I don't have that same ability with the Count column, which is what i really need.

How do I sort in descending numerical value here?

Thank you

Answer 1

You should have a More Sort Options entry below the sort A-Z and Z-A options. If you click that, you should have an option to sort using the value field.