I have several teams with different number of staff. And I want to see the staff sales ranking in his own team. Can any body knows how to deal with this? Thanks.
Solved! Go to Solution.
Hi @LeiCheng ,
The Tile tool actually offers a nice clean way to do this. Just group on the team and ensure the data is sorted prior to Tiling your team members. See image below & workflow attached.
Regards,
Tom
Hi @LeiCheng,
you could use the Multi-Row Formula tool. Attached a sample workflow. Let me know, if it works for you.
Best,
Roland
Hi @RolandSchubert It's quite helpful. Thank you!
Hi, @RolandSchubert, I have a further inquiring, if some of the staff have the same sales such as in Team A, staff B and D both completed $500, then their ranking will be 3, 3, no 4, and then C should be rank 5 instead of 4. How can I solve this problem?