4 Replies Latest reply: Nov 19, 2012 9:29 AM by Haider Al-Seaidy RSS

    Rank Total

      Hi all,

       

      I am struggling with something seemingly simple! I need to return the maximum rank from a table. e.g. from the table below, I need to return 6 on every record.

       

      Sales AmountRank
      102
      204
      305
      456
      51
      153

       

      Any help greatly welcomed as my brain is not functioning properly today!

       

      Regards

       

      Haider