ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   sorting sub groups in pivot tables (https://www.excelbanter.com/excel-discussion-misc-queries/242016-sorting-sub-groups-pivot-tables.html)

Patty Slowik[_2_]

sorting sub groups in pivot tables
 
In my pivot table I am adding 4 fields to row labels, 1-ID 2-last name
3-first name 4- courses. The pivot table sorts by my first choice (ID, which
I need to be 1st choice because its the unique identifer) So one person
could have 4 courses and this is how it looks, but i also need the data in
courses to be sorted alpha.

2 Smith Joe Math
English
Science
4 Jones Mary Band

Any suggestions


All times are GMT +1. The time now is 10:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com