TopN

[Anonymous]

Hi,

I am trying to build a table that will only bring back the top 20 seller and another that brings back the bottom 20 sellers from a data set. I thought i had achieved this with using the TopN filter. However when data sets change the number of rows brought back is random and never sticks to the 20 mark that i want it to do. Can anyone point me in the right direction of what i am doing wrong.

Thanks,

[judspud · Accepted solution]

Hi @Anonymous,

You could add 2 columns to the dataset. One using RANKX ascending and one using RANKX descending. 

Then use the additonal columns to filter the visuals to only show ranks of 20 or less.

Hope this helps.

Thanks,

George