5 Replies Latest reply: Oct 21, 2017 12:31 PM by Anand Chouhan RSS

    CALCULATE VALUE FROM RANK SELECTION

    Philippe BONNIN

      Hi

       

      I want to calculate the quota of the TOP FIVE sectors for the margin indicator in a KPI

       

       

      Dimension SECTORS

      Measures  : SALES

                          COST

       

      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

       

      Philippe