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.