pivot table not returning proper results with logic

i'm fairly new to excel (only been using it a few years) and i have had the same issue each time i have to use this file and i am never able to fix it. i have no idea if it is the logic, but the pivot is never returning the correct results in numbers. it can get a bit more complicated than i am putting it, but i wanted to put it here to see if anyone else could figure it out without having to get into the gritty details. i am not able to speak to the person who created it. however, i am the one expected to fix the issue and i havent been able to fix for months. i'm at a bit of a loss.

here's an example of the issue (this is what the numbers are meant to be)


This is what the numbers in the pivot table come out as:


I am wondering if the logic is off. i would like to thank anyone with advice in advance...

Why should "Attacks on Critical Infrastructure Disrupting TD Operations" be 140?

The sum of column AB (Current Quarter Current Total) in sheet Q3 is 144 when you filter column W (Threat #) for 2 and column A (Threat) for "Attacks on Critical Infrastructure Disrupting TD Operations".