Pivot Table doesn't copy values as sums

Hello, this is my first post. I have attached the excel.

This is a first for me. I usually solve problems with a simple google search but can't seem to find an answer. i'm starting to think my excel is bugged or something. I'll be doing the work manually in the meanwhile.

Theres a data table and a pivot table made from the data table.

Theres some values on PROFIT column in data table that are not appearing as their real values on the pivot table, they appear as a 0, when they should appear as the value on the table.

So far, this issue only happens to EA 12344444 (check for the column) but I'm sure it's happening to others but I would have to check one by one to see if the pivot table has copied the data table value correctly. It's unbelievable!

I have highlighted the areas that should appear on the pivot table.

I thought it had to do with them being as text, so i checked and fixed it. But it's still showing a 0.

Please help, I'm going crazy! and I need to analyze this data as soon as possible.

Thank you very much

very strange. However, when I brought the Data into Data Model. Check box at the bottom of the navigation window that opens. it presented properly.