4 Replies Latest reply on Feb 21, 2013 2:25 PM by Jayaraj Palaniswamy

    Rank is always 1

    Jayaraj Palaniswamy

      Hi,

       

      I would really appreciate if you someone can help me on sorting out and ranking the data in the file. When i try to do rank it was says "1". Any pointers on how to create Rank for Groups will be appreciated.

       

      I am doing an YOY Growth percent and highlighting it Red/Blue based on Growth. Now i want to rank within an pane for each pane.

      Hierarchy Structure: Business Area --> ZoneCode --> Site_BI_CertNum

       

      Any pointer on details about now Rank/Index work will be helpful for Hierarchy or Group By.

       

      Thanks

      Jay