3 Replies Latest reply on May 11, 2017 9:15 PM by Norbert Maijoor

    Rank at Category Level, Ignoring Segment Breakdown in Tableau V9.2

    franklin.quansah

      Hello, sheet1 shows order quantity of a list of items. The colors represent different customer segments within each category of items. What I want is to have a rank at the Category level (ignore the customer segment) so that a user of the report can filter by this rank, determining to show the top 5, 6, 7 etc as in sheet 2. In this scenario,

      Telephones and Co....  will be 1

      Binders and Binder ....  will be 2

      Tables                     ....  will be 9

       

      Without the customer segment, this is fairly straight forward.

      Thanks for your help

       

      Sheet1.jpgSheet2.jpg