Here are a few threads that are similar to your situation.
1 of 1 people found this helpful
The easiest way is here. No need of set, nor of index()
Also be careful of what you mean by Top N
Thanks for the reply.
I am looking to show top 10 and bottom 10 in 2 worksheets with the same measure value and dimension.
2 of 2 people found this helpful
Remove the set. It is not needed in your case. Just use the filters as
Top N filter: Rank_Unique(Sum(Measure))<=N
Bottom N filter: Rank_Unique(-Sum(Measure))<=N
On Mon, Jul 20, 2015 at 1:39 AM, Gallop Tab <