I have a Pivot Table with about 15 columns. Each row has a unique item in it. Specifically, it has an ID# and a Name, then the rest of the columns are just attributes for that item.

In one of my columns, it pulls the "Max of Sum of XXXX"... how can I filter all my row items from largest to smallest based on this max column?

I've tried the conventional way of click on the column "Max of Sum of XXXX", going to the Pivot Table Options, A to Z sort, but that doesn't work. Nothing happens to my pivot table.