Sorting in pivottables

R

Roger Govier

Hi

Yes.
Double click on the field you want sorted>Advanced>Sort Ascending>Using
field - use the dropdown to select Sum of whatever your data filed is.
 
T

traima

Hi Roger,

I'm having some problems understanding this.. My pivottable looks like this


Data
Ship from Sum of kollies Sum of FBV
City A 88 792
City B 14 86
City C 101 911
Total 203 1789

If i doubleclick on the header (Sum of kollies), i get an error message;
cannot show or hide detail for this selection. If I doubleclick on the
datavalue 88 (in the first row), the details for these shipments show. What
am I doing wrong?

Traima



Roger Govier skrev:
 
R

Roger Govier

Hi

Double click on Ship From, and then do what I said, choosing Sum of
kollies as the sort field.
 
T

traima

Thanks - now I know how to sort by the cities, but if I want to sort by the
sum of kollies?

traima

Roger Govier skrev:
 
R

Roger Govier

No, I you chose the dropdown for Sum of Kollies, then your row field
City, will be sorted by the Sum of Kollies, not alphabetically by City
Name.

Take another look at your data and see.
 
Top