9 Replies Latest reply on Oct 26, 2016 6:21 AM by muruganantham kb

    How to find Top N values when using multiple dimensions in row shelf

    muruganantham kb

      Hi,

       

      I am very new to tableau and trying to create a dashboard on supplier analysis. I have a country dimension as filter. Then Supplier and Products in row shelf. For the country selected i want to see only the top 5 suppliers for that country across all products by value.

       

      Filter : Country : Germany and below are all the suppliers for Germany. Out of which how do i select only the top 5 supplier ?

       

      Supplier 1 : Across all products total value is 100

      Supplier 2 : Across all products total value is 90

      Supplier 3 : Across all products total value is 85

      Supplier 4 : Across all products total value is 70

      Supplier 5 : Across all products total value is 69

      Supplier 6 : Across all products total value is 65

      Supplier 7 : Across all products total value is 63

      Supplier 8 : Across all products total value is 60

      Supplier 9 : Across all products total value is 50

      Supplier 10 : Across all products total value is 40