I am connecting to SharePoint list to excel and downloaded data for a report that i am attempting to created.
Data that i am using from SharePoint list is project team, project name, original project completion date, and Actual project completion date.
I have created calculated field that subtracts original project completion date from Actual project completion date which gives me variance. I have also added project team as filter so i can view result for each team.
Here is issue that i don't know how to solve:
- I like grand total to show average of delay in project rather than total delay by project team.
- I like to see how many how many % of projects are completing with only 2 days or less variance.
- I like to see this data for each quarter.
The reason i like to use pivot table is so i can just refresh the data.