| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table question
hello again roger, Your solution does get me the desired result but it is not dynamic; everytime I change departments, i need to redo a count for all positions. (since what you suggested was not part of the PT and the number of rows displayed changes). I thought there was a way to get just the number of employees who followed a training session - easily. I guess not... I will continue looking for a solution when I can... in the meanwhile I suppose this will have to do. I get the impression the data would have to be reformated a little to prevent the sum of all sessions followed... thank you for your help louis -- 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 | |||
Threaded Mode
