Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
If you are using QV12 or above.. try the attached
The second image is Excel sample data that I'm trying to get it. I've update my question now, please refer above
If you are using QV12 or above.. try the attached
you are awesome @sunny_talwar , thank you very much