I want to show only the top 10 results

tableaucommunity@tableau.com — Thu, 15 Jun 2017 13:16:05 GMT

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:

COUNTRY	MAY
Costa Rica	755,500
Germany	300,000
France	250,000
Italy	249,500
UK	249,000
Argentina	245,500
Mexico	245,000
China	205,000
Switzerland	200,000
Australia	145,000
Netherlands	125,500
Ireland	125,250
Spain	125,000
Canada	75,000
Brazil	60,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!!!

Column & Row Dividers

tableaucommunity@tableau.com — Tue, 15 May 2012 13:41:38 GMT

Is there a way to omit the column line on the far right and the row divider at the top of the graph? I only want to see the x and y axis line -- don't want the graph in a 'box' format. Thank you.

Content in Tableau Community Forums

I want to show only the top 10 results

Column & Row Dividers