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


      Can some one help me please.