David11011
asked on
Sorting Excel pivot table
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?
SalesMix-With-ItemDescriptions.xlsx
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?
SalesMix-With-ItemDescriptions.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER