Pivot Table Count is not accurate

[jondavis1987]

So I have a table that a pivot table is drawing from I have a column in the table labeled number of tests. inside the current year is pasted just to have data to count. In my pivot table I'm trying to have the average of %AC , the StdDev of %AC, and the count of number of tests. So my pivot filters have date, month, year, yard, material. In values i have Average of %AC, StdDev of %AC, and Count of number of tests. The problem is for 2020 Millings its saying there's only 42 tests but theres actually 50 in the table it's drawing from. Below is the pivot table and then the table it is drawing from

Date	(All)
Month	(All)
Year	2020
Yard	Waterloo
Material	(All)
Average of %AC	StdDev of %AC	Count of Number of Tests
4.66%​	0.30%​	43​

Date	Month	Year	Yard	Material	%AC	Number of Tests
5/20/2016​	May	2016​	Sunnylane	1/2" Rap	4.4%​	2016​
7/14/2016​	July	2016​	Sunnylane	1/2" Rap	4.6%​	2016​
10/5/2016​	October	2016​	Sunnylane	1/2" Rap	4.9%​	2016​
10/12/2016​	October	2016​	Waterloo	1/2" Rap	4.2%​	2016​
11/2/2016​	November	2016​	Waterloo	1/2" Rap	4.7%​	2016​
11/19/2016​	November	2016​	Sunnylane	1/2" Rap	4.2%​	2016​
11/22/2016​	November	2016​	Waterloo	1/2" Rap	4.7%​	2016​
12/8/2016​	December	2016​	Sunnylane	1/2" Rap	4.6%​	2016​
5/24/2016​	May	2016​	Sunnylane	Millings	5.4%​	2016​
7/14/2016​	July	2016​	Sunnylane	Millings	3.7%​	2016​
9/15/2016​	September	2016​	Waterloo	Millings	4.9%​	2016​
9/15/2016​	September	2016​	Waterloo	Millings	4.8%​	2016​

 

[jondavis1987]

Well.... Turns out I forgot to set the pivot table to automatically refresh the data when opening the file