1 Reply Latest reply on Jun 17, 2016 1:35 PM by Michael Hesser

    Show only 5 bests

    Esteban Mann


      I have this database and I want to make a graph only showing 3 better (by Gain) with a filter by country.



      If I want a graph Gain vs Company

      When I filter Chile, show only company "Una", "Dos" and "Seis"

      When I filter Argentina, show only company "Diez", "Doce" and "Ocho"

      When I filter Colombia, show only company "Treinta", "Quince" and "Ochenta".




        • 1. Re: Show only 5 bests
          Michael Hesser

          Hello Esteban...

          I started with a Rank calculation...


          Then filtered by Country and Rank


          In the Rank filter, I chose Range of Value = 1 to 3 (I wasn't sure if you wanted top 3 or top 5)


          I dropped Gain, Country, and MSO on Columns/Rows:


          ...and made sure the Country Filter was visible (with no ALL button)


          Does this work?

          1 of 1 people found this helpful