% in Pivot Reports

[Guest]

Hi,

I have a file that identifies which resources work from home during the
work. For example, some resources might work Monday & Tuesday from home,
some might work Wednesday & Friday, etc.

The file contains resource name, dept manager, people manager, etc plus has
5 columns for each day of the week. For whichever day a resource works from
home, there is a 1 under that day of the week, ie for resources working
Monday & Wednesday, there would be a 1 under Monday & Wednesday.

I am trying to do up a pivot report to show a) the details of each person
(rolled up by manager) and b) % of resource that work from home by people
manager under dept manager.

I can't get b) to work.... I don't want % of total as this is not the
breakdown I'm looking for. I've tried using % of by Dept Mgr and/or People
Mgr, but I get an error instead.

How do I get this to work?

Thanks, Mary-Lou

 

[Debra Dalgleish]

Add a column (HomeDays) to the source table, and sum the weekday
numbers, e.g.: =SUM(F2:J2)
Add another column (WorkDays) to the source table, and enter the days
per week that each employee works, e.g. 5

In the pivot table, create a calculated field that divides the HomeDays
by the Workdays, and format it as percent.

 

[Guest]

Great, thanks very much!

Mary-Lou.

Add a column (HomeDays) to the source table, and sum the weekday
numbers, e.g.: =SUM(F2:J2)
Add another column (WorkDays) to the source table, and enter the days
per week that each employee works, e.g. 5

In the pivot table, create a calculated field that divides the HomeDays
by the Workdays, and format it as percent.