Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
As such
=Aggr(Only({$<[Active] ={"Active"}>} [Version]), [Version])