Link to home
Start Free TrialLog in
Avatar of David11011
David11011Flag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of Jerry Paladino
Jerry Paladino
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of David11011

ASKER

Wow! thanks for the screenshots. nice reply. that fixed it.