2 Replies Latest reply on Jul 30, 2012 5:35 AM by angie.johnson

    I want to show only the top 10 results

      I'm trying to show only the top 10 results of my query.  It's a simple query ... country usage by month.  I have numerous countries with usage and I only want to see the top 10.  But I cannot do the Filter Top 10 option becuase it looks at the entire data source. I did try the "Finding the Top N Within a Category" option, but that didn't work.

      Below is a sample set of what I'm looking at:

       

      COUNTRYMAY
      Costa Rica755,500
      Germany300,000
      France250,000
      Italy249,500
      UK249,000
      Argentina245,500
      Mexico245,000
      China205,000
      Switzerland200,000
      Australia145,000
      Netherlands125,500
      Ireland125,250
      Spain125,000
      Canada75,000
      Brazil60,000

       

      Set up in Tableau---

      COLUMNS: Month

      ROWS: Country

      TEXT: Sum(Usage)

       

      Any suggestions ... I'm getting very frustrated with something that should be pretty simple.  Thank you!!!