This content has been marked as final. Show 5 replies
I want to calculate the quota of the TOP FIVE sectors for the margin indicator in a KPI
Measures : SALES
and MARGIN = SALES - COST
so in my KPI i 'm waiting for
SUM( top five (SALES-COST)) / SUM (TOTAL (SALES - COST))
Can you help me to find the right syntax using RANK ?
thank's in advance