I've attached a file containing the data I'm working with. If you look on the Pivot Watch List tab you will see a column labeled "Sum of $ Change".
I would like to sort this column from lowest to highest and only see the top 10 values so that our marketing team will know which product groups are losing the most money from year to year.
When I try to sort the pivot table it gives me this error
"AutoSort and AutoShow cannot be used with custom calculations that use the positional references. Do you want to turn off AutoSort/Show?"
I click Yes but nothing happens. Any ideas on how to sort this list?