rodrigo_solares
New Member
- Joined
- Mar 6, 2007
- Messages
- 44
Hello to everybody,
I have a pivot table displaying the departments in the row section... and it's counting 2 things with 2 different fields; how many employees by department should be doing a course, and how many employees have already taken the course.
The real question is that i want a field inside the Pivot Table diplaying by row, what's the % of people who have taken the course.
Lets say that there should be 30 people in Finance in that course, but only 15 have taken it.. therefore the field should display 50% (15 of 30 in Finance department) instead of the % of the Total which sumarizes all departments.
Btw, i have tried to use the other "% of" options in the pivot table but i keep getting a N#A error.
Thanks in advance!
I have a pivot table displaying the departments in the row section... and it's counting 2 things with 2 different fields; how many employees by department should be doing a course, and how many employees have already taken the course.
The real question is that i want a field inside the Pivot Table diplaying by row, what's the % of people who have taken the course.
Lets say that there should be 30 people in Finance in that course, but only 15 have taken it.. therefore the field should display 50% (15 of 30 in Finance department) instead of the % of the Total which sumarizes all departments.
Btw, i have tried to use the other "% of" options in the pivot table but i keep getting a N#A error.
Thanks in advance!