1 of 1 people found this helpful
Sure now I find this, after working out quintiles using Index.
[INDEX]<(LOOKUP([INDEX], LAST() +0 )*.25)
OR [INDEX]> (LOOKUP([INDEX], LAST() +0)*.75)
Thanks a ton Russell !!!!
It was really helpful !!!!
Keep up the good work
2 of 2 people found this helpful
One line of code will do it all:
- Rank_unique(sum([Sales]))<=5 or Rank_unique(-sum([Sales]))<=5
Use it as a filter and you are done.
that is fantastic.
Are you aware there seems to be bug in the slider(?), sometimes for the top N the view show Top n-1.
Okay - I don't mean to resurrect this, but...
I want to create a Top N and Bottom N set - using Chris R's solution above. The By Field includes every dimension and measure in my primary data source EXCEPT the one measure calculated using inputs from my primary and secondary data source (and it was created in my primary data source). I don't understand why it is not there (9.1.1)
Alexander...regarding your 1 line script for top/bottom N.....all I can say is...Marvelous!!!!!!!!!! Thank You Thank You Thank You....I had been using a very complicated script to accomplish what you achieved so brilliantly and elequently...Thank You! I've seen may examples of ideas to accomplish this task. But this is the best!
It's very easy and handy but when I'm trying to get Top and Bottom 10 by using filter of region then It doesn't work properly.
Can you please suggest me any solution for this?
Here I am attaching my workbook of sample super store. Please go through Top & Bottom 10 sheet.
if I want to see top and Bottom 10 region wise then it's not giving proper result(Region= south).
Tableau_suman_Practice.twbx 2.2 MB