Pivot Table Calc showing Percent

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!

DiliPandey - - I'm pretty sure I've tried this, I will however try again and post my results. I'll see if I can create a sample file, smaller and post if I need more help on this...thank you for your reply!

DiliPendy - I've attempted what you suggested and it's almost there, I've attached an example file, can you take a look and see if there is another suggestion.

Basically I have a couple of categories that I want to get %'s of the next category up, then up to the next, then the % of the grand total, kind of like a teir...I hope that makes sense...take a look and let me know...thanks!