Thank you for your help.
I have one more question though.
Your aggregation makes perfect sense, but is there a way to display the aggregated # and the items of the max of the aggregation.
From the example top, can I do this? (From your attachment)
Order # Item 1 Item 2 Item 3 Item 4 Count (Aggr) 1 Box Blue Box Red - - 2 (Max of Aggr) 2 Cup Blue Cup Red Cup Green - 3
So basically, while getting the count also get the items of the rows with largest count value.
Do I need different function for this?