2 Replies Latest reply: Feb 12, 2013 5:08 PM by Raj vadde RSS

    Rank Functions

      I am attempting to use Rank in a straight table and it is not working correctly.


      This is an example of my two data tables



      Company NameMoney
      Company A10
      Company B20
      Company C45
      Company D15
      Company E25
      Company F



      Group NameCompany Name
      Group 1Company A
      Group 1Company B
      Group 2Company C
      Group 3Company D
      Group 3Company E
      Group 3Company F


      So I then set up a straight table that looks like this


      Group NameMoneyRank
      Group 130-
      Group 2451
      Group 370-

      My Rank formula is rank(Money), it is only ranking the one group that only has one company under it. Is there a way to fix this?