I am working on a problem with pivot tables in excel. As you can see, I have the columns set up as a type of clock hour as my values, they are either listed as "regular" or "overhead".
The employees, whoa re represented by letters either work for jobs or overhead.
With this spreadsheet I am able to show the total of regular and overhead hours they worked compared to the total, but I would like to also have a column in the Pivot Table (not an external column) that calculates the % of hours that are job charged (job charged hours/total hours).
I have attached screen shots of the pivot table and the data source...
Bookmarks