Hey all - - Excel Gurus...I have problem with modifying a pivot table.....currently it's displaying counts by EmpID, which is fine. I have included Category and a Sub Category. showing the counts is fine but I want to show/display the percent of the total of the category above and then again above that. I've tried changing the settings and it just dosen't seem to do the trick.
Here's a breif (I hope) explanation of the data:
The source data sheet contains employee type data, EmpID, Location, Department, Type (this is FullTime, PartTime, FlexTime..etc), Actual Hours Worked (this is a key field). The idea is, if I'm a full time Employee I should be working 40 hours a week. The source datasheet will show this, if I'm a FullTimer but only actually working 25 hours a week...etc....
So, if a department has 4 Fulltime Employees at a given location and 1 employee works 20 hours and the other 3 work 40, my Pivot Table is showing this with a "1" for <30 hours category and "3" for category 35-40. What I want is instead of "1", I want that to be 25%, and for the "3", 75%...etc.
How do I accomplish this? Do I use one of them calculated/formula fields you can add to the pivot table? Just wondering what might be the best way to do this...thanks for all the thoughts/suggestions/ideas....blessings to you all!
Bookmarks