Forum Discussion
Top N by gift amount?
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.
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.
2 Replies
- Greg_Deckler
Community Champion
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.
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 :smileyhappy:.
