Filter list using list property

kristenr

Hi

Hoping someone can help me solve this issue I am having. Probably doing something very silly!

I want users to filter a list of managers which is a subset of the employee list. I wanted to do this through a list property driven by a line item in the model. I have done this before but I cannot seem to get the dependent check box as editable when I am creating the line item with the property. Here is my Employee List. I want the user filter to only show those with Manager = Active.

Here is the line item with the Employee list but the Dependent check box is non-editable.

Thank you

AjayM

Hey @kristenr ,

For the 'Manager' lineitem which is formatted by employee list, it couldn't find the dependent value ('Active' in this case), in any other lineitem. Simply create a non-dimensioned lineitem with format same as that of the list you used for 'Manager' property in the employee list.
And write a formula to always populate 'Active' value in that lineitem (assuming you always need only active employee to show-up in the drop-down). And then try setting the dependency. Alternatively you may leave this blank and let the admin choose 'Active' vs any other value they might want to switch to in future, as the source of dependency.

Cheers!