Filter Pane - Conditional options shown

Markbhai — Wed, 24 Apr 2024 22:07:50 GMT

Is it possible to populate a filter pain based upon criteria from another field.

I have a table for document version, this contains [Version] and [Active] - [Active] has only two values, 'Active' or 'Deleted'

I want to show Version in my filter pane, but only if the Version is Active.

Thanks

Mark

Re: Filter Pane - Conditional options shown

BrunPierre — Thu, 25 Apr 2024 10:30:17 GMT

As such

=Aggr(Only({$<[Active] ={"Active"}>} [Version]), [Version])