PLEASE HELP!! Pivot table showing incorrect sums

[illsonds]

I have a file with order data, and I am trying to create a pivot table that shows how many of each type of meal were ordered. This should be extremely simple, but the sums showing in the pivot table are way lower than they should be. For example, the Pasta Free Butternut Squash Lasagna_L, is showing a sum on the pivot table of 135. However when you manually sum that column (AD) in the data tab, you get 542. I need to figure out why the sums are incorrect, how to fix it, and also how to get the pivot table to refresh when data is changed or added (when I manually change a number in the data and press refresh, nothing happens).


Any ideas GREATLY appreciated!!

 

[RAF43]

My guess is that your value field setting is not set to SUM the column. Once your pivot table active, select the value field drop down menu and make sure it is set to sum the column you wish, and not count or some other function.

Randy

 

[sheetspread]

Be sure the filter is turned off, otherwise it will exclude records.

 

[illsonds]

It was the filter! Thanks so much to both of you