I have the following table which I need to rank each person by their group. I will need to create a KPI object with the rank for the person selected. For example if Leo is selected, even if his rank is 3, the rank within his group should be 2.
I have already created a variable to get the current group for the person selected. Can someone show me how can I get the rank within sub group? Thank you!
![Capture.PNG Capture.PNG](https://community.qlik.com/t5/image/serverpage/image-id/20300i4EA6091C6DD0A7CD/image-size/large?v=v2&px=999)