I have a Pivot Table report with a distinct count that is working fine going across the rows, but when it shows the Grand Total, i want it to sum the counts above it.  Right now it is showing something different.

This is made up data, but it represents my report.  This is a report showing each customer, and how many different brands they bought.  

Customer Name	Brand	Customer.Distinct Count
ToysRUs	Lego	1
	Barbie	1
	Hot Wheels	1
Walmart	Lego	1
	Barbie	1
Target	Barbie	1
	Hot Wheels	1
Grand Total		3

The Grand Total is currently showing '3' for the 3 different customers.  I need it to show the actual sum of the numbers above it, which would be 7.If I change the Distinct Count field to be counting on the Brand Name field, it only shows me '3' also because there are 3 different distinct brands.  Any idea on how to get it to show 7?