7 Replies Latest reply: Jun 23, 2016 7:47 AM by Rohit Kumar RSS

    Rank in table

    Rohit Kumar

      Hi ,

       

      I am facing an issue in rank function. Scenario is I need to create a table where there are multiple dim and measure and one rank column.

       

      Serial No working as a primary key, Gateway is a dim and rest are measures:

       

            

      S.NOGatewayTotal SaleTotal WaybillActual WeightCharge Weight
      1BANGALORE2,454,8401,113178,394198,321
      2CHENNAI2,236,050585173,361210,762
      3DELHI2,103,823851149,282173,547
      4GREATER MUMBAI2,050,251965131,233158,786

       

       

      Now if I Sort the table on the basis of CHARGE WEIGHT It will give me the result below one :

       

       

            

      GatewaySum([S.NO])Sum([Total Sale])Sum([Actual Weight])Sum([Charge Weight])Sum([Total Waybill])
      CHENNAI22236050173361210762585
      BANGALORE124548401783941983211113
      DELHI32103823149282173547851
      GREATER MUMBAI42050251131233158786965

       

       

      But My Requirement is below one

       

       

            

      GatewaySum([S.NO])Sum([Total Sale])Sum([Actual Weight])Sum([Charge Weight])Sum([Total Waybill])
      CHENNAI12236050173361210762585
      BANGALORE224548401783941983211113
      DELHI32103823149282173547851
      GREATER MUMBAI42050251131233158786965

       

      So conclusion is , If there is a key like Serial no it will not let me sort on the basis of measure , You can add a dimension at Edit option and see  and if I remove the serial no it will let me sort on the basis of any measure but I am looking for a solution which let me sort even if Serial No is in table .

       

      I am attaching an app where I have added one rank column and you can see sort is not working