# Dynamic Filter on Lookup

**URL:** <https://air.tableforums.com/t/dynamic-filter-on-lookup/1381>\
**Category:** Fields and Formulas\
**Created:** [December 3, 2024, 1:23pm UTC](https://air.tableforums.com/t/dynamic-filter-on-lookup/1381 "2024-12-03T13:23:52Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![JBJ](https://yyz1.discourse-cdn.com/flex029/user_avatar/air.tableforums.com/jbj/32/1063_2.png) [@JBJ](https://air.tableforums.com/u/JBJ)\
**Post date:** [December 3, 2024, 1:23pm UTC](https://air.tableforums.com/t/dynamic-filter-on-lookup/1381/1 "2024-12-03T13:23:52Z")

</div>

![image](https://canada1.discourse-cdn.com/flex029/uploads/tableforums/original/2X/e/e26d1d173d321cf65bfe033484ca77171ebea900.png)

Hi guys,

On my [Revenue] table, I’m trying to compute the expected revenue that I’ll get from a client. The client processes payments twice a month after the work sessions are completed. We have struck a deal that spans multiple payment periods.

To this end, on my [Revenue] table, I’m trying to set a dynamic filter on a lookup of the `Sessions` field, which is itself a lookup on the [Deals] table. I want the `Sessions` field on the [Revenue] table to display only the sessions – hourly sessions or weekly sprints – that ended after the `Work Period Start Date` and before the `Work Period End Date`. This would then allow me to sum the compensation due for each session within this work period with a rollup.

The thing is, it seems I can’t set up a dynamic filter on a lookup.

Do you guys confirm?  
If so, which workaround would you suggest?

Thanks for your help.

---

<div class="post-metadata">

**Author:** ![ScottWorld](https://yyz1.discourse-cdn.com/flex029/user_avatar/air.tableforums.com/scottworld/32/5_2.png) [@ScottWorld](https://air.tableforums.com/u/ScottWorld)\
**Post date:** [December 4, 2024, 12:05pm UTC](https://air.tableforums.com/t/dynamic-filter-on-lookup/1381/2 "2024-12-04T12:05:15Z")

</div>

That is true. That is one of the limitations of Airtable. I don’t think I know of any workarounds for that.

---

<div class="post-metadata">

**Author:** ![JBJ](https://yyz1.discourse-cdn.com/flex029/user_avatar/air.tableforums.com/jbj/32/1063_2.png) [@JBJ](https://air.tableforums.com/u/JBJ)\
**Post date:** [December 4, 2024, 6:10pm UTC](https://air.tableforums.com/t/dynamic-filter-on-lookup/1381/3 "2024-12-04T18:10:26Z")

</div>

That’s what I thought. Thanks for your help.