I have a pivot table based on 8,360 Rows of data.

The pivot table has Report Filters set resulting in a total count of 2,823 lines (VALUES section of the Pivot returns SUM of a data column with either 1 or 0).

If I double click the grand total amount in the pivot table, it displays 3,918 lines of source data. (all of which have a value of 1 listed in the column being looked at in the VALUES section of the pivot table.)

When I filter the source data directly to match the filters on the pivot table, I get 3,918 lines of data.

If I set the VALUES section of the pivot to return a COUNT it displays the 3,918 total.

why would the SUM and COUNT calculations of the VALUES section be different if the returned data has all 1s in that specific column being looked at?

I hope I've explained my issue clearly. If not, let me know and I'll try to explain in more detail. Any insight is appreciated.

r/

SUPPO