How I can add categories in a pivot table?
 

I have two questions:

First One-

Can I group and then sum categories included in a pivot table report?

I have a table which lists which divisions bought what, now I need to group
those products by the manufacturer. In the same table if possible. The data
is right there but I can't figure how to do it. Can I insert a calculated
field in my table and group them? I have no more than 7 sub-categories to
add together and 3 possible groups.

Second One

My pivot table has a field that counts all the other entries and its
calculating wrong. Its missing 32 entries (out of 1500). ??? Any ideas
what might cause that?


Thanks,


Todd L.