Pivot Table Data Grouping

Hi.
I have a problem that I am sure there is a very simple solution to. I have a table with sales data in:

Please Login or Register  to view this content.

I want to get the total of each product sold so I used a pivot table:

Please Login or Register  to view this content.

But what I now want is to have the types of each product in the pivot table too without showing all the orders. The end result should be like this:

Please Login or Register  to view this content.

I thought about just putting the types next to each product and not in the pivot table at all but then when I change the sorting or filtering of the pivot table all the types will be in the wrong place.

It there an easy way of doing this?

Thanks.

The order will still be based on Product rather than Type.