Can I make my pivot table subtotal certain records?

[phil152003]

My data set consists of Name, Product, Price (its actually a lot more complicated, but this simplified version still gets the point across).

Now, its a very long list of data, and the majority of people only have one product. However, occasionally a person will have more than one product.

On my pivot table, I have name as the first column, then product as the second column, and the sum values as price. There is a subtotal on Name.

This all works as I want, but the problem is more a visual one - as the pivot table is very long, there are many unneccessary subtotals (just duplicating the line above for each 1 product person - 90% of a very large data set) that just clutter up the table.

I was wondering if there was a way to make the pivot table only show a sub total for people that only have more than one product?

 

[phil152003]

To make it easier for you to understand, I've created a mock table demonstrating what I mean.

http://img703.imageshack.us/i/picturefb.png/

Looking at the screenshot, you can see that five of the six names in the pivot table only have one record, so the subtotal row isn't particularly necessary. Only for 'Mr E Smith' is the subtotal row useful.

My question again, is if there is a way for the pivot table to only display the sub-total for, in this example, Mr E Smith, while all other names don't have a sub-total?

 

[phil152003]

*One last ditch attempt at someone having an idea*