Group sorts can be done on a report level so that the records are sorted and removed as necessary. However, there are times when the records will be needed in the overall report but not in a cross-tab. Why not just do a group sort or Top N on the cross-tab? Remember that Xtreme only wants to see its top 10 countries in this report, so let's complete this last step.
Xtreme Mountain Bikes now has a report that answers the original request a summary report to provide a quick glance of its shipped orders. |