Need help with Expression

[bhaveshp90]

Hello, 

I have a table with correct YTD and MTD values shown below; 

I am trying to create a pivot table as shown below

So, When I removed Month and Project Number from my original table the YTD and MTD values are changed? I tried multiple ways to fix this but I didn't get the correct values as my original table. (as shown below)

What should I change in my YTD and MTD expression so that I can avoid Project Number and Month in the pivot table? Attached is the file for reference.

thanks

Bhavesh. 

[pradosh_thakur]

from the screenshot it seems like it is showing the correct total . The green in country column in the first tab shows you have china selected .So the YTD and MTD are matching those of china.I see nothing wrong here unless i am missing something obvious.

[bhaveshp90]

The second image is Excel sample data that I'm trying to get it. I've update my question now, please refer above

[sunny_talwar · Accepted solution]

If you are using QV12 or above.. try the attached

[bhaveshp90]

you are awesome @sunny_talwar , thank you very much