Hi Statalist!

I am so please to be on board this great list that I have often used with great please. Now I have a question of my own:

I have data that looks like this:
ID ID_of_Leader Employee_score Mean_employees
1 . . .
2 1 0.2 0.4
3 1 0.4 0.4
4 1 0.6 0.4
5 6 0.5 0.5
6 . . .
I have calculated the mean of the employees using egen with bysort, but now I want to create a new variable that capures the mean of the employees on the relevant leader and I can’t figure out how to do this. Can anyone help me?

Best regards
Aske