6 Replies Latest reply: Feb 14, 2013 9:24 AM by chand S RSS

    Rank repeating

      Friends:

       

      i want to calculate revenue for 2 years , difference and then rank them.

       

      My straight table looks like below. My current Rank expression is rank(Sum([% growth]),0,1)

       

       

      Market    Revnue 2008          Revenue 2010       % growth          Rank

      A            3800                       4369                    569                      1

      B            77                           151                     74                         1

      C            58                            99                      41                         1                   

      D            35                            74                      38                         1                   

      E            59                             79                    20                           1

      F             28                             44                    16                           1  

      G            0                                0                       0                           1  

       

      Not sure why i am not getting the correct rank. I tried different options of Rank as given in QV help but getting the same results.

       

      Please help.