Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting in pivottables
Is it possible to sort a pivot-table by values in the data area?
traima |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting in pivottables
Hi
Yes. Double click on the field you want sortedAdvancedSort AscendingUsing field - use the dropdown to select Sum of whatever your data filed is. -- Regards Roger Govier "traima" wrote in message ... Is it possible to sort a pivot-table by values in the data area? traima |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting in pivottables
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: Hi Yes. Double click on the field you want sortedAdvancedSort AscendingUsing field - use the dropdown to select Sum of whatever your data filed is. -- Regards Roger Govier "traima" wrote in message ... Is it possible to sort a pivot-table by values in the data area? traima |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting in pivottables
Hi
Double click on Ship From, and then do what I said, choosing Sum of kollies as the sort field. -- Regards Roger Govier "traima" wrote in message ... 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: Hi Yes. Double click on the field you want sortedAdvancedSort AscendingUsing field - use the dropdown to select Sum of whatever your data filed is. -- Regards Roger Govier "traima" wrote in message ... Is it possible to sort a pivot-table by values in the data area? traima |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting in pivottables
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: Hi Double click on Ship From, and then do what I said, choosing Sum of kollies as the sort field. -- Regards Roger Govier "traima" wrote in message ... 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: Hi Yes. Double click on the field you want sortedAdvancedSort AscendingUsing field - use the dropdown to select Sum of whatever your data filed is. -- Regards Roger Govier "traima" wrote in message ... Is it possible to sort a pivot-table by values in the data area? traima |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting in pivottables
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. -- Regards Roger Govier "traima" wrote in message ... 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: Hi Double click on Ship From, and then do what I said, choosing Sum of kollies as the sort field. -- Regards Roger Govier "traima" wrote in message ... 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: Hi Yes. Double click on the field you want sortedAdvancedSort AscendingUsing field - use the dropdown to select Sum of whatever your data filed is. -- Regards Roger Govier "traima" wrote in message ... Is it possible to sort a pivot-table by values in the data area? traima |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Sorting Sorting | Excel Discussion (Misc queries) | |||
sorting non contiguous ranges | Excel Discussion (Misc queries) | |||
Advice sought: Multiple column sorting | Excel Worksheet Functions | |||
sorting number in ascending order | Excel Discussion (Misc queries) | |||
Adding a KeyID column for sorting | New Users to Excel |