I need to create a headcount report which displays data by tiers. The problem is that for each group, I need to display the data by different tiers. For Example,

For the Private Client Group, I need to see it grouped by Tier 1 then Tier 2.

For the Capital markets group, I need to see it by Tier 2 and Tier 3

How do I set this up without having to create 30 individual queries?

Thank you for your help in advance.

Take a look at Grouping and Sorting in the report....