Pivot Table aggregate sum is wrong, how to sum without aggregate?

[cesarmontoya]

• 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
  
  Pivot Table disable aggregate sum, keep sum only? confused!
  ​