Top N by gift amount?

[danielrsnyder]

Hello, 

I am trying to display the Top 5 gifts by gift amount in the table below, but I am not able to get a Top N filter to work? The visual level filters for my gift amount field (formatted as a decimal number) do not give me the Top N filter option. Also, I have seen this thread about top N filter for a measure, but the gift amount field is not a measure? Any ideas? I want to use this in conjunction with a year filter so users can easily see the top 5 gifts each year.

[Greg_Deckler · Accepted solution]

I really want to know what kind of gig you have going. I wish I had the problem of figuring out who gave me $4M and $2M versus a measely $1M. 🙂

See image below on Top N filter, it is working for me. Your issue might be that you have ties. If you have ties, TOP N treats those as the same "rank" if you will so you can end up with more than you specify.

[danielrsnyder]

Thanks @Greg_Deckler! I needed to add the gift amount filter in a second time and not use the one that was automatically included when I added that field to my visual. 

I do have a pretty good gig going though .