How to Disable a Parent Filter When a Child Filter is Selected, and Vice Versa?

[Deleted User]

Hello Anaplanners,

I'm working on a filter setup where Category is the parent of Task in a hierarchy. I need help implementing the following logic:

• The Category Filters should be disabled when any of the Task Filters are selected.
• The Task Filters should be available when none of the Category Filters are selected.
• If a Task Filter is selected, the Category Filter becomes inactive, and if a Category Filter is selected, the Task Filters become inactive.

umangsinghal

This can be achieved by applying DCA logic.

Create 2 line items:

DCA Category : Boolean formatted, Formula - Not Task , Summary: All

DCA Task: Formula - Boolean formatted, Formula - Not Category , Summary: Any

Choose DCA Category in Category lineitem for Read Access Driver and Write Access Driver

Choose DCA Task in Task lineitem for Read Access Driver and Write Access Driver

Hope this helps!