Count a number of men or womens who he part of Top 10 Salaries of enterprise or group of enterprise
I have a problem with a particular KPI:
I have to calculate the number of men and the number of women present in the TOP 10 of the highest remuneration of the company or of a group of companies (hierarchical dimension).
It is very simple to present in a graph the TOP 10 Remunerations by year and by Dimension Hierarchique and to color it by the Gender, but on the other hand, if one wants to count then the number of women and men I do not know to do. Do you have any ideas ?
I have post an file with datas in exemple. I am in Qlik Sense November 2018.