0 Replies Latest reply: Aug 2, 2011 11:13 AM by Suprasanna RSS

    To get the top n values for a specific id by a another column

      Hi All,

      I have three fields Code,Name and index.

      I need to calculate the name field such that in a pivot table when i expand code it has to give me the top 20 names by the index.

       

      i have attached the sample document showing the chart that i need.

      i used something like

      =aggr(if((rank(sum([Index]))<=20),Name),Name)

      Can some one help me please.

       

      Thanks.