Pivot Sort Question

[Shadefalcon]

Hello all,

I'm having trouble with sorting my Pivot Chart a specific way, and I was hoping someone could help. I made a chart based on two columns, SKU's and Representative Name. I want a Pivot table that shows each Representative Name, with each of the SKU's using that Representative Name listed underneath, but I want it sorted so the Representative Names with the Most SKU's are listed at the top. Please see attached file. In essence, I would want "607850P" and "SJGFKLDS4" to come up before "SSDDFFFGGG" and "123DDD". I'm sure this is probably an easy fix, but I'm still pretty new to Pivot tables, and this is just a small example of my issue, the real table is a lot bigger.

Thanks,

M

[etaf]

under the pivot table options
theres a sort
click on the represenative name in the row label
and then sort descending and use the drop down to choose by count of sku

i have attached a screenshot , if that helps

[Melvinrobb]

1. Click on the arrow beside "Row Labels"
2. Select "More Sort Options"
3. Select "Descending (Z to A) by:"
4. Select "Count of SKU" in dropdown

[Shadefalcon]

Thanks guys.

[etaf]

your welcome