# Dynamic filtering of multiple items

**URL:** <https://community.glideapps.com/t/dynamic-filtering-of-multiple-items/72196>\
**Category:** Ask for Help\
**Created:** [March 31, 2024, 9:00pm UTC](https://community.glideapps.com/t/dynamic-filtering-of-multiple-items/72196 "2024-03-31T21:00:23Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [March 31, 2024, 11:15pm UTC](https://community.glideapps.com/t/dynamic-filtering-of-multiple-items/72196/3 "2024-03-31T23:15:09Z")

</div>

I think you can do this with a little creativity in grouping items in a collection (assuming you need the grouping text to say just like what you lined out in your post).

Create a query column in your reviews table, and filter by reviewer company is this row \> reviewer company, and reviewed company is this row \> reviewed company. A rollup over that query would give you the total count.

Then construct your pluralized column (1 =\> 1 review, others =\> X reviews).

Finally a template so that we get X review/reviews for … from …

Add a collection and allow filtering by the reviewed company, and group by the template above.

---

_[View the full topic](https://community.glideapps.com/t/dynamic-filtering-of-multiple-items/72196)._