Pivot Table

[cslauenwhite]

I have a pivot table where I am trying to sort based on the Topbox Percent. I have tried the sort function but it sorts on the count not the percent column. I have attached so you can see what I am talking about.

[caveman144]

If your pivot table is based on a query, just enter the word descending in the sort box of your percent field.

[cslauenwhite]

If your pivot table is based on a query, just enter the word descending in the sort box of your percent field.

There is no percent field. This is created in the pivot table.