Posted to microsoft.public.excel.misc

Patty Slowik Patty Slowik is offline

external usenet poster

Posts: 1

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
HELP... Pivot table sorting	Michelle	Excel Discussion (Misc queries)	6	July 27th 09 12:56 PM
Pivot Table sorting	Soccer boy[_2_]	Excel Discussion (Misc queries)	1	February 10th 09 08:15 PM
Sorting a Pivot Table	cware	Excel Worksheet Functions	2	August 26th 08 12:27 AM
Pivot Table Sorting	dale1948	Excel Worksheet Functions	0	August 25th 06 12:10 AM
Pivot Table Sorting	jesterhs	Excel Discussion (Misc queries)	0	August 4th 05 06:38 PM

All times are GMT +1. The time now is 11:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us