I have a database of about 100,000 timesheet entries, with total hours broken down into regular hours, overtime hours (1.5x) and double-time hours. Other fields include the name of the person billing, project, the task they are billing to, time in, time out, date, pay period etc etc. The data is in a table, and I'm creating pivot charts to look for various trends. I am able to easily chart the number of hours worked in many different ways, but what I really would like to see are percentages and chart those. The idea is to avoid having to add my own calculations to the data which I then chart. I'm hoping pivot tables and charts can provide me with percentage calculations without my having to manually add those calculations into the data.
For example, for a given project I would like to chart the percentage of overtime and double-time for a given date range or pay period. So a question might be, what percentage of total hours billed were overtime and double-time hours on project X for pay period 3? I have the total hours, overtime hours and double-time hours in the data set, and IGrand Totals are also generated by the pivot table. Can I plot the percentage of overtime and double-time from just this data? It's an additional calculation that doesn't exist in the data set.
Hoping someone can shed some light on this for me. I'm fairly new to pivot tables and charts.
Thanks!
Bookmarks