Excel Data Model Pivot Table Grand Total

[wsnyder]

Hi all,

Using Excel 365.

I highlighted my data >> Insert Pivot Table >> Add this Data to Data Model.
I added fields to Page Filter, Filtered for a vendor
I added document # to Rows and Distinct Count of Type to Values
There are 44 Document #'s and the Distinct Count of Type for each Document is 1.

However, the Grand Total Row shows 7.
Why is that?

Thanks,
-w

 

[wsnyder]

Bump.