pivot table sorting

P

Patty Slowik

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
 
J

Jim Thomlinson

If you switch the order of student name and ID it should sort itself in Alpha
order.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sorting sub groups in pivot tables 1
Sorting by field in a report 2
Pivot Table Count Issue 6
How do I print a report base on it's subreport's sorting. 2
Help with a timetable Table 4
Date/Time issue with Pivot Table 3
Sorting multiple columns (fields) in a pivot table 1
Shading pivot table based on value in 1st column 5

Top