hello roger,

thank you for you help. but I still get the same end result.

FYI, an employee can only be in 1 department and position. (one of the
examples I gave was "englishized" for comprehension purposes..)

What does increase the number, is the fact that any given employee can
follow more than 1 training session. Instead of 868, I should have
around 300, which is the total number of participants which have
followed a training session.

so if an employee followed 4 sessions, he should be counted as 1 and
not 4. That's the crux, I cannot change the count... I was looking into
doing a count.if but cannot do so since this is a pivot table, and I
could not specify conditions... (could this work????)

I'm now thinking of rearranging the data/table.... Theres also the
possibility of creating a calculated field... but this also seems a
little complicated...


hoping someone might help me figure this out... thx
louis


--
louisp
------------------------------------------------------------------------
louisp's Profile: http://www.excelforum.com/member.php...o&userid=25880
View this thread: http://www.excelforum.com/showthread...hreadid=511160