View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Patty Slowik Patty Slowik is offline
external usenet poster
 
Posts: 1
Default pivot table sorting

I add multiple fields to the row labels so I can summarize data, in the
following example my data is summarized by course #(9243), then teacher
name(cortese), then student id(which is a unique ID that needs to come before
student name), then student name. What I need is to have the student name
sorted alpha for each teacher. Any suggestions?



9243 Cortese, Cynthia 130056 Willerth

130123 Gabriel

306873 Serafin-Yehl
308277 Stoyanov

Gabriel, Lori 300668 Laketic

300983 Wacyk
301107 Aylesworth

302193 Kaufmann