Dynamic Filter on Lookup

[JBJ]

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.

[Mike_AutomaticN]

Hey @JBJ! Please let me get back later today to try to understand what is it that you are trying to do LOL.
In the meantime, I can for sure confirm that you cannot dynamically set up a dynamic filter on a lookup.

Mike,  Consultant @ Automatic Nation

[JBJ]

Hey @Mike_AutomaticN,

Thanks for offering your help. I solved my problem in a dirty way.

Take care.