I have more than 100 employees where their performance is based on different KPI’s, how is possible to creat a Dashboard where I can view all the employees overall scores in visible way and to see the top 10 as well as the team overall
Hi Mohamed,
Welcome to our forum! I suggest you use a scroll and sort table for your 100 employees scorecard. I hope that points you in the right direction. If you'd like to learn more Dashboard techniques like this, please consider my Excel Dashboard course.
Mynda
Mynda Treacy said
Hi Mohamed,Welcome to our forum! I suggest you use a scroll and sort table for your 100 employees scorecard. I hope that points you in the right direction. If you'd like to learn more Dashboard techniques like this, please consider my Excel Dashboard course.
Mynda
Hi Mynda
thank you for your advise that would sort the issue from one side
In addition the data that I’m generating it’s required arround 7 graphs where they have to be sorted from higher to lower performer
So how this would be possible with one pivote only, rather than creating the manually
tnx