| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to pull extra info into Pivot table report
I have a pivot table report that displays ONLY the resources that left or
started with the company (grouped by manager). The execs would now like to see percentages: a) percentage of resources left/entered against # of employees under a manger b) percentage of resources left/entered against the total # of employees How would I go about doing this for a pivot table report? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to pull extra info into Pivot table report
Calculate those percentages in the source table and then refresh the pivot
table and place those values where appropriate. -- Brevity is the soul of wit. "MLK" wrote: I have a pivot table report that displays ONLY the resources that left or started with the company (grouped by manager). The execs would now like to see percentages: a) percentage of resources left/entered against # of employees under a manger b) percentage of resources left/entered against the total # of employees How would I go about doing this for a pivot table report? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to pull extra info into Pivot table report
Thanks. I will try that.
"Dave F" wrote: Calculate those percentages in the source table and then refresh the pivot table and place those values where appropriate. -- Brevity is the soul of wit. "MLK" wrote: I have a pivot table report that displays ONLY the resources that left or started with the company (grouped by manager). The execs would now like to see percentages: a) percentage of resources left/entered against # of employees under a manger b) percentage of resources left/entered against the total # of employees How would I go about doing this for a pivot table report? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can a pivot table pull from multiple worksheets? | Excel Worksheet Functions | |||
| pivot table created from another pivot table | Excel Worksheet Functions | |||
| Pivot Table Report Parameters to be named and saved like 'View' na | Excel Discussion (Misc queries) | |||
| Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
| combining 3 columns of same info for a pivot table | Excel Worksheet Functions | |||
Linear Mode
