1 Reply Latest reply on May 21, 2012 11:18 AM by Tracy Rodgers

    Find top 100 items when the result contains non unique values


      Hello Tableau Users,


      I am faced with this absurd problem where I am partially able to get want I want but cannot filter my results.


      I have list of Items that can be Ordered using multiple order numbers . I am able to sort the items and Get  a huge list : Most selling to least selling items. But now I want to filter it to top 100 items only.

      I want to know my top selling 100 along with order numbers that can be used to order the item.

      Since each item can have multiple order numbers the list is filtered to top 100 order number . :-(


      Any help is really appreciated