Sorting Values in a Pivot Table

Please see the attached file w/ a pivot table on the 2nd sheet. I want to do something that should be simple but I can't figure it out. I want to sort the Lacking Specificity=YES column in descending order so that the PDX with the most "YES"s appears at the top.

I've tried every combination of sort and custom sort that I can think of and I can't get it to sort. What is the magic answer?

Thanks!

Hi,

Please check the attached file and see if this is what you needed. It's pretty simple, keep the cursor in the respective column & use SORT A-Z or Z-A button.

Thanks so much - I was trying to sort with my cursor in the column header, not in the first cell of data.