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

S.O
S.O
in Modeling

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.
image.png

Tagged:

Best Answer

  • umangsinghal
    umangsinghal
    Answer ✓

    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!

    Regards,

Categories