# Is there a way to show top 3 most frequently (used) items by the same user?

**URL:** <https://community.glideapps.com/t/is-there-a-way-to-show-top-3-most-frequently-used-items-by-the-same-user/57703>\
**Category:** Ask for Help\
**Created:** [February 9, 2023, 3:58pm UTC](https://community.glideapps.com/t/is-there-a-way-to-show-top-3-most-frequently-used-items-by-the-same-user/57703 "2023-02-09T15:58:28Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [February 9, 2023, 7:29pm UTC](https://community.glideapps.com/t/is-there-a-way-to-show-top-3-most-frequently-used-items-by-the-same-user/57703/9 "2023-02-09T19:29:21Z")

</div>

This should help to eliminate duplicates. This is an excerpt from a different post.

> [@Filter out duplicate items](https://community.glideapps.com/t/filter-out-duplicate-items/48988/2):
>
> Ultimately I would probably set things up differently. But to stick with your current setup, what you can do is create a template column that joins Business and Category together. Using that template, create a single relation back to itself. Then create a Lookup column that returns the Row ID from the relation. Finally create an IF column that checks if the Row ID matches the Lookup Row ID. If it’s a match, then return true, else false. Or you could probably just have the IF column return the Category name. This will give you a boolean value of true (or Category name) only in the rows that have that Business/Category combination the first time it appears in the data.

This will give you an additional value that you can use in la filter.

---

_[View the full topic](https://community.glideapps.com/t/is-there-a-way-to-show-top-3-most-frequently-used-items-by-the-same-user/57703)._
