For example, if Ford sells vehicles... They sell Trucks, Coupes, Sedans, Hybrids, etc.

Those would be considered product categories. We need to be able report on product categories. Versus sales on each individual product.

Reporting on each individual product is far too detailed and cumbersome

We have 100's of products.