I have this issue with Tableau Aggregation, It's not summing up correctly on Barchart

Hi,

I badly need your help on how to solve this issue I tried different approaches but it's still not summing up correctly.

Please see pic 1 - This shows that I have two values to be added but on the 1st Column(SUM ACTUAL EXPENSES) ,2nd Column(AGG CALCULATION), 3rd Column(SUM CALCULATION)

If I removed the dimension that separates them, it's not adding the value to around 2.5m but it only gets the result from one Item. which is weird.

Regards,

King