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.
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.