How to pull extra info into Pivot table report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Calculate those percentages in the source table and then refresh the pivot
table and place those values where appropriate.
 
Calculate those percentages in the source table and then refresh the pivot
table and place those values where appropriate.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Tables 3
Excel 2007 - Pivot Table and Calculated fields? 1
Percentage of a "sum of" amount in a different field of a pivot re 2
Average of Subtotals in Pivot Table 0
Pivot Table Comparison 1
Total two pivot tables into one 5
Pivot Table Grouping 1
Pivot Table Percentage of Sub-Total 7

Back
Top