not sure I understand your issue.

If you want to have less rows in the pivot table then you can create a label that can be used in the pivot table which pre-summarises some of the data and then use that label to group by. (For example, put a label which says "Rev" or "COGS" beside each sales and cost of sales account)

Also, if the data is presently displayed like..

product category
product 1 100
product 2 100
product 3 100
------
300
------
you can 'double-click' the 'product category' heading and the individual product lines will be 'undisplayed'

Some techniques for manipulating data are discussed in an (old!) article at www.adaxa.com.au - use the search field to search for the word 'pivot'.

regards...