Hello Folks,
I am trying to perform a PIVOT calculation.
From the available data, I would like to know the Total count of Incomplete Projects.
For this, I have a PIVOT with,
1. Total number of Projects
2. Total number of Completed Projects.
But, I am unable to implement the DIFFERENCE FROM by adding a new Column. Could someone please help me where I am doing wrong.
Thanks in advance.
P.S: Attached an excel file with the example.
Bookmarks