Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table question
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 | +-------------------------------------------------------------------+ -- louisp ------------------------------------------------------------------------ louisp's Profile: http://www.excelforum.com/member.php...o&userid=25880 View this thread: http://www.excelforum.com/showthread...hreadid=511160 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table question: How to display total and percent for data simultaneouly | Excel Discussion (Misc queries) | |||
pivot table created from another pivot table | Excel Worksheet Functions | |||
Pivot Table Question | Excel Discussion (Misc queries) | |||
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question | Charts and Charting in Excel | |||
pivot table question, sum fields? | Excel Worksheet Functions |