1 Reply Latest reply on May 25, 2016 7:35 AM by Steve Burger

    Displaying only the top n customers for each selection

    Kumar.0001

      Hi, I have a dashboard in which there are 3 sheets. I am checking "use as filter" for all 3 sheets in the dashboard. I want only 10 customers to be displayed in the sheet1 section of the dashboard. So, even when we select some area in sheet2 or sheet3 of the dashboard, I want exactly the top 10 customers(arranged in descending order of sales) to be displayed in sheet1 of the dashboard. Attached is the workbook. Please help.

        • 1. Re: Displaying only the top n customers for each selection
          Steve Burger

          Good Morning Roushan,


          There can be a couple of ways to do this, but here is a method with minimal steps:

           

          Open workbook

          Go to Sheet 1

          <ctrl>click on the SUM(Sales) Measure on the Rows Shelf and drag a second copy to the right.

          Right click on the second copy and choose 'Quick Table Calculation' and then 'Rank'

          You should see the second axis assign an ascending value to each customer 1,2, 3, etc..

          Then rick click the second copy of SUM(Sales) again, and select 'Discreet'. the pill will change to blue and move to the far left of the Rows shelf.

          Drag that blue, discreet pill to the filter shelf, and select the discreet boxes 1-10 with a check. click 'apply' or 'ok'.

          That should work, but test.  Looks like you have fewer than 10 customers in Mongolia and Nepal, so obviously you won't have 'top 10' in those selections.

           

          Attached iss the workbook with solution applied.

           

          If you found this response helpful and/or it solved your problem please mark it accordingly!


          Thanks,

           

           

          Steve Burger

          Tableau Online Deployment Advisor

          1 of 1 people found this helpful