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.