Pivot table subtotal partial sum not calculating correctly
So I have a pivot table where I simply want the subtotal (partial sum) to be the sum of the row values.
I read a ton of posts and me & a colleague spent about 7 hours trying every form of SUM and AGGR we could think of, but simply cannot get it to total correctly.
On the attached example, Overspend for A should sub total -60 and not -35, and Underspend for A should total 25, but come back with nothing !, similarly subtotals for B should be -43 and 153 respectively.
Can anyone please assist here with some Christmas magic ?!?!?!?