I asked this question and got a good answer but I didn't ask correctly.
I have a table
2 Apparel Women
3 Apparel Men
This table is joined to a Retailer table
RetailerID RetailerName CategoryID CategoryName Sales
1 Special1s 2 Apparel Women $234
2 Preworn Goods 3 Apparel Men $54
3 All Parts 4 Electronics $123
4 Intiments 2 Apparel Women $343
Now the problem is that the client wants all the Apparel "type" combined in the report. So instead of the report displaying 3 kinds of Apparel they want
Category Total Retailers Total Sales
Apparel 3 $631
Electronics 1 $123
My question is, how do I combine the 3 results into 1? I need to retain the 3 categories for other reports as well.