# 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:** 7\
**Page:** 2

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/96552_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [April 21, 2024, 11:24am UTC](https://community.glideapps.com/t/dynamic-filtering-of-multiple-items/72196/21 "2024-04-21T11:24:46Z")

</div>

Okay, so given that the goal is to get a list/count of reviews per Company:

I’ll assume that you don’t currently have any computed columns in any of the tables you’ve listed.

- In your Reviews table, add a single relation column that matches the ReviewFor column with the same value in your People table.
- Use a lookup column to fetch the Company name/identifier via that relation.
- In your Companies table create a multiple relation column that matches the Company identifier with the same value in the Reviews table (the lookup column).
- Use a rollup through that relation to get a count of reviews for each company.

I guess you can probably figure out the rest.

---

<div class="post-metadata">

**Author:** ![hirereach](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hirereach/32/58130_2.png) [@hirereach](https://community.glideapps.com/u/hirereach)\
**Post date:** [April 22, 2024, 7:50pm UTC](https://community.glideapps.com/t/dynamic-filtering-of-multiple-items/72196/22 "2024-04-22T19:50:15Z")

</div>

@Darren_Murphy I feel like I’m missing something basic here; maybe I’m overthinking it?

I built what you described in your last response, above (very clear, thanks!)…but it’s still counting/rolling up the total reviews by all companies for TargetCompany (4 total reviews), like this…

A) Reviews for TargetCompany:

- Company ABC, Company XYZ, Company 123
- 4 reviews

…instead of what I want: how many reviews by each company for TargetCompany, like this:

B) Reviews for TargetCompany:

- Company ABC, 2 reviews
- Company XYZ, 1 reviews
- Company 123, 1 reviews

Am I making any sense? Or missing some simple logic?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/96552_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [April 23, 2024, 1:36am UTC](https://community.glideapps.com/t/dynamic-filtering-of-multiple-items/72196/23 "2024-04-23T01:36:49Z")

</div>

Can you show me the configuration of the Rollup column?

It sounds like you might not be targeting the relation correctly.

---

<div class="post-metadata">

**Author:** ![hirereach](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hirereach/32/58130_2.png) [@hirereach](https://community.glideapps.com/u/hirereach)\
**Post date:** [April 23, 2024, 10:27pm UTC](https://community.glideapps.com/t/dynamic-filtering-of-multiple-items/72196/24 "2024-04-23T22:27:30Z")

</div>

Sure thing. The names are long, so they get cut off if I take a screengrab. Does this work?

In **Companies-Table**

Rollup column name: {ReviewFor-RelationLookupRollup}

- Configuration: {ReviewFor-Table-RelationLookup}
  - (Which is the multi-relation column name matching CompanyRecID values in **Reviews-Table** )

- Calculate: Count

Does that help?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/96552_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [April 24, 2024, 12:16am UTC](https://community.glideapps.com/t/dynamic-filtering-of-multiple-items/72196/25 "2024-04-24T00:16:27Z")

</div>

No, please show me a screenshot.

The reason I asked for a screen shot is because as soon as I see that I will know whether or not it is correctly configured. I cannot deduce that from you describing how it is configured.

---

<div class="post-metadata">

**Author:** ![hirereach](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hirereach/32/58130_2.png) [@hirereach](https://community.glideapps.com/u/hirereach)\
**Post date:** [April 24, 2024, 11:06pm UTC](https://community.glideapps.com/t/dynamic-filtering-of-multiple-items/72196/26 "2024-04-24T23:06:32Z")

</div>

Like this?

Companies-Table → ReviewsFor:

 ![Screenshot 2024-04-24 at 7.03.22 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/e/9ed40db0901545d4216732f67620b28e53b0af89.jpeg)

And, in case it helps, Companies-Table → ReviewsFrom:

 ![Screenshot 2024-04-24 at 7.04.01 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/a/2a8f34382378466eb8e281b62cbd2cfb4283113e.png)

Is that what you’re looking for?

Also, see the screen grab below from Companies-Table. For Target Company A, you can see 2 reviews from AT&T and 2 reviews from Humi, etc. I need a _single_ field that lists how many reviews a company has from all other companies.

**Target Company A reviews:**

- 2 reviews from AT&T
- 2 reviews from Humi
- 1 reviews from dripdrop
- 1 reviews from Rose Rocket
- 1 reviews from [Kritik.io](http://Kritik.io)

**Target Company B reviews:**

- 1 reviews from 6ix
- 1 reviews from SkillsCamp
- 2 reviews from Autumn
- 1 reviews from dripdrop

 ![Screenshot 2024-04-24 at 7.09.02 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/2/925f48888040b9ffbdbd7174001b4e2393a943b4.png)

---

<div class="post-metadata">

**Author:** ![hirereach](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hirereach/32/58130_2.png) [@hirereach](https://community.glideapps.com/u/hirereach)\
**Post date:** [May 1, 2024, 7:16pm UTC](https://community.glideapps.com/t/dynamic-filtering-of-multiple-items/72196/27 "2024-05-01T19:16:23Z")

</div>

@Darren_Murphy @ThinhDinh Does what I posted here help clarify? I’m trying to get all this in one field in Data, not multiple fields stacked on each other by using Layout.

[Previous page](https://community.glideapps.com/t/dynamic-filtering-of-multiple-items/72196.md?page=1)
