Pivot Table disable aggregate sum, keep sum only? confused!

Hey guys,

I need to get rid of the aggregate sum and modify it to show just the sum of one column on a pivot table:


Sum of INV $ is a formula, which multiplies sum of AVG * cost (which is not shown).

The sum of INV numbers are correct, however if I collapse the category (blank), I get an aggregate number of $7,799,893.63, which is the sum all of AVG * sum of all cost, in this case this number is wrong.

How can I make it show the CORRECT number when I collapse the Row Label? (correct number should be SUM OF INV ONLY; $7,481.52 + $2501.15 + etc = $68,597.70

Thanks in advance

I understand that an xls file would help, but in this case its a simple formatting setting.
Thank you for the heads up!