Pivot Table not picking up all values
I have a pivot table that for some reason is not correctly totaling the data. When I sum the count column in the data and compare to the sum column from the pivot table - I am short. The two totals should match. Any suggestions? I copied all the data as values to see if there were formulas or something I didn't see but that didn't fix the discrepancy. What could possibly be causing this? I do not want to manually subtotal 60,000 lines of data!! I appreciate ANY help I can get!!
Check source range of pivot table. Any subtotals in source data?
I suppose pivot table returns less data.
1. Check if pivot data uses all data from the source table.
2. Are there any subtotals in source data?