pivot tables
Train Strikes - 7th, 8th & 9th May 2024
Hide
Contact Us About Resources Consent preferences Sign in

TrustPilot

starstarstarstarstar Excellent

Request Callback We will call you back  0207 987 3777 Call for assistance Your Basket Basket is empty
Callback Sign in Basket
Menu

Call us on 0207 987 3777 or Search our website

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Tables

Pivot Tables

resolvedResolved · Medium Priority · Version 2010

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


 

Excel articles

Please browse our web site to find out more about
excel+vba+training and other training courses.

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips


Request Callback

We will call you back

0207 987 3777

Call for assistance

Security verified Microsoft Partner

Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom

Terms & Conditions Privacy & Cookie Policy Consent preferences

Server loaded in 0.04 secs.