View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default 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