I am trying to create a subtotal of a specific product type while still getting the individual totals for all the other products. For example, I have a table that lists all the product types with a group name for each product.
Group Name ProductTypeCode
I need to get the count of each of the different types of cars, like
Car CA_ELEC 25
Car CA_GAS 100
Car CA_DIESEL 40
Car CA_HYBRID 5
but I need a total for all trucks, like
and then continue with the other types, like
Van Panel 50
Van HighTop 25
where 500 is the total for all trucks categories added together.
I'm not sure how to get the count for just the trucks and the individual counts for each of the other individual types.
Thanks for any help anyone can provide and hope this makes sense