Filter Pane - Conditional options shown

[Markbhai]

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

[BrunPierre · Accepted solution]

As such

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