Pivot Table is not picking up all values from Filter Table

Occasional Visitor

Hi Team,


I hoping if you can help me fix my OneDrive Excel. 

After manually adding up the numbers, I found out my Pivot Table is not picking up all the values listed in the Filter Table from another sheet.

I tried a lot of the recommendations to get it fixed but I think I missing something here. Can you please help me with it. I can send you a copy of my excel document. Can you please provide me an email for this request.



2 Replies

Hi @lillina,


Let's take a look at your workbook, you can click on my name and private message the file to me.





Welcome to your Excel discussion space!

If you’re looking to ask a question or start a conversation about Excel, you’re in the right place!  Ask away.


Please include the following info to help others answer your question:


Once you got a good answer to your question, please accept it as solution to help others looking for answer to the same/similar question.