Just put the item you want subtotaled in the middle of the pivot table. Now
add the other dimension to the rows and columns to reneder the appropriate
subtotals. Not too sure what you wnat to hide as that will show the
appropriate aggregations with no more or less detail than you have placed in
the rows and columns.
