forums

Use these forums to ask questions and discuss Tableau.

Top 10 Filter Incorrect

Posted April 29th, 2008 by corbinmatthews
in Calculations

Hello,

I am trying to filter the top 10 results based on the sum of a particular field, however I know that the result I am getting from the filter is incorrect. Please look at the two attached images for evidence of this. How do I fix this?

Thanks!

AttachmentSize
Pre-Filter.PNG12.88 KB
Post-Filter.PNG9.57 KB
Add new comment

Comments

On April 29th, 2008 James Baker said:

My guess is: Try filtering your Cost Center ID instead of your Amount. I think you want to see the top 10 Cost Centers.

reply
On April 29th, 2008 corbinmatthews said:

I am filtering as follows:

Top 10 Cost Center ID by Sum of Amount.

I have attached screenshots to verify this. Please advise!

AttachmentSize
Filter.PNG64.13 KB
Post-Filter.PNG61.72 KB
Pre-Filter.PNG60.38 KB
reply
On April 29th, 2008 Aaron said:

In my experience, erroneous "Top N" results are due to having multiple filters. Tableau does not perform filters in any particular order, thus it may be finding the Top 10 results, then applying another filter that excludes some of the ten.

The solution is to "Add to Context" all other filters other than the "Top N" filter. Try that out and let us know if it works.

reply
On April 29th, 2008 corbinmatthews said:

Fantastic! That was, indeed, the solution!

Thank you!

reply