Filter list formatted line items based on list property

Ajaykumar08ns

Hello All,

I have a challenge where I need your expertise to achieve it.

I have a system module for Resources where I have attribute called Employee Type (Permanent, Temporary).

I have reporting module applied with Territory and BU. In this I have line items with Resource list formatted.

I need to create a filter line item to select the Employee type (Regular, Temporary) once I select employee type my reporting module line items should filter the resources based on the employee type selected.
Could someone please suggest how I can achieve this.

Prajjwal88

Hi @Ajaykumar08ns ,

One way to achieve this is by creating another line item that retrieves the employee type using a LOOKUP from the Role line items. You can then compare this employee type line item with the selected employee type from the lookup module.

Or You can use multiple OR's in the final filter line item as shown,

However, when applying the filter, since there are multiple Role line items that can contain the selected value, other cells will also be visible. For example, if Row 2 contains both Temporary and Regular employee types, it will still be shown because the filter uses an OR operator.

One way to handle this is by creating separate line items with logic like:
If selection= SYS Resource.Emp type[LOOKUP: 'Role1'] then Role1 Else blank
This way, only the relevant values will be displayed in the report, effectively hiding the others.

Hope this helps!