Hi.
I'm trying to find out how to create a pivot table showing the relationship between a superior position and his/her subordinates. And if possible to count how many there are based on the name of their positions.
I've used (=vlookup) to identify the reporting line.
I'm not trying to draw a hierarchy/structure in Visio / smart art -graph, I need to be able to count how many people are under a certain person in the reporting line.
PFA is the example of my problem and expected results.
I would appreciate any help that i can get.
Thanks in advance, and sorry for my English.
Bookmarks