L
louisp
Hello,
I have another problem, this time using Pivot tables.
Using Win XP SP2, on Excel 2000 (SP3).
I have a list with the following data sets: employee position,
department and name of training session attended. This is a list of
employees that have followed a training sessions. (1 empl. can follow
more than 1 session)
The desired result is a table displaying the total number of employes
who have followed a training session, with the information sorted by
position and department. (there can be the same position in different
dpts.)
I was able to construct the table but my problem is that I get a total
of all training sessions followed - not the number of all employes who
have followed a session. My number is much bigger than it should be.
I cannot modifiy the field options to get the numbers of different
employes who have followed a session.
See attached pics. Data is an example of the data source, and pivot
table is my table with the total counts. Note that employee's position
is on the left (catégorie poste) and department is on the top (service).
Instead of 868, I should have around 300... (since the table counts
total training sessions instead of total number of employees trained)
Can anyone help me???
thank you very much!!!
Louis
+-------------------------------------------------------------------+
|Filename: DATA.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=4349 |
+-------------------------------------------------------------------+
I have another problem, this time using Pivot tables.
Using Win XP SP2, on Excel 2000 (SP3).
I have a list with the following data sets: employee position,
department and name of training session attended. This is a list of
employees that have followed a training sessions. (1 empl. can follow
more than 1 session)
The desired result is a table displaying the total number of employes
who have followed a training session, with the information sorted by
position and department. (there can be the same position in different
dpts.)
I was able to construct the table but my problem is that I get a total
of all training sessions followed - not the number of all employes who
have followed a session. My number is much bigger than it should be.
I cannot modifiy the field options to get the numbers of different
employes who have followed a session.
See attached pics. Data is an example of the data source, and pivot
table is my table with the total counts. Note that employee's position
is on the left (catégorie poste) and department is on the top (service).
Instead of 868, I should have around 300... (since the table counts
total training sessions instead of total number of employees trained)
Can anyone help me???
thank you very much!!!
Louis
+-------------------------------------------------------------------+
|Filename: DATA.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=4349 |
+-------------------------------------------------------------------+