| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
% in Pivot Reports
Great, thanks very much!
Mary-Lou. "Debra Dalgleish" wrote: 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. MLK wrote: 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 Contextures http://www.contextures.com/tiptech.html |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot reports | Excel Worksheet Functions | |||
| How do I create calculated items on pivot table reports? | Excel Worksheet Functions | |||
| how to print reports from pivot table | Excel Discussion (Misc queries) | |||
| Pivot Reports and < or values | Excel Discussion (Misc queries) | |||
| pivot reports - limit report to last 20 dates | Excel Worksheet Functions | |||
Threaded Mode
