Sorting/Grouping Compare 2 Lists Problem

[dmdiener]

My first post here, be gentle...

Training report scenario. I have two curriculums. Each curriculum contains various courses. I need to create a report that compares the two lists of courses in a specific way. It needs to be formatted like this:

At the top of the report it should first list all the course IDs that appear in BOTH curriculums.
Those should be followed by all the course IDs that appear ONLY in Curriculum A.
Those should be followed by all the course IDs that appear ONLY in Curriculum B.

I'm very close. I currently have the report grouped by Course ID and then I have a summary field giving me the count and I sort by that count in descending order. So the top part of my report is all set. The problem I am running into is the rest of the Course IDs listed (the ones that only appear in one of the two curriculums) are left sorted by Course ID so those are a jumbled mix of Curriculum A and Curriculum B courses. I want those remaining course IDs to be sorted (or grouped) together by the Curriculum IDs.

Is there any way I can do this? Any suggestions as to a better/different way to approach this?

 

[lbass]

Insert a maximum on the curriculum field at the courseID group level and then do a second group sort using the maximum of curriculum ID as the sort field. This will cluster the course IDs according to curriculum.

-LB

 

[dmdiener]

Thank you so much, that worked perfectly!