Jackie has attended:
Access Intermediate course
Access Advanced course
Advanced Excel Dashboards course
Excel PowerPivot course
Pivot Tables
Hi I have recently attended the Excel Advanced Dashboard course. We have a spreadsheet that we want to create a dashboard but need to get our Pivot Table correct first.
We have multiple data entries each month from various contractors working across various projects. The data includes the results of a monthly score sheet. We have managed to create a pivot table to show the data for each contractor and their score as a percentage of the total score of 45. Some contractors work on more than one project each month therefore their sum score isn't a true reflection and we need to find a way to calculate their average score based on how many projects they are working on that month.
As this varies from month to month we cannot work out how to calculate this. Can you help please?
Thank you.
RE: Pivot Tables
Hi Jackie,
Thank you for your post. If you have a column in your normal Excel sheet which shows the number of projects a contractor is working on, you could add a calculated field in your pivot table which calculates the score based on number of projects. If this sounds useful, I can tell you how to do it. However, if you manage the data differently, we could look at a different solution.
Please let me know.
Kind regards
Marius Barnard
Excel Trainer
