Sorting in pivottables

[Guest]

Is it possible to sort a pivot-table by values in the data area?


traima

 

[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.

 

[Guest]

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:

 

[Roger Govier]

Hi

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

 

[Guest]

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:

 

[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.