View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default Selecting examples from a table

Pivot Table Field City Field Settings Advanced Top 10
Show Top 1 Using Field: Sum of XXX
XXX is some other existing or new numerical field.
Sample file at:
http://www.savefile.com/files/1693942