How can I create a dependent drop-down that filters a K3 list based on the selected K1 context?

Sharmali
Sharmali
in Modeling

I want to create a dependent drop-down list within a hierarchy in Anaplan. I need a line item formatted as a list (K3), which represents the lowest level of the hierarchy. The goal is for users to select one of these K3 list items, but I also have a context selector on the page set to the highest level of the hierarchy (K1). I want the drop-down in the line item to dynamically filter and display only the K3 list items that belong to the selected K1 in the context selector. I followed the micro-lesson on dependent drop-downs, but the dependent list option is grayed out when I try to enable it in a module.

What could be causing this issue, and how can I resolve it?

Best Answer

  • pyrypeura
    pyrypeura
    Answer ✓

    Hi, The Dependent dropdowns are utilising list properties. In your K3 list add property K1 with K1 format and formula PARENT(PARENT(ITEM('K3 List'))). When you have this list property the dependent drop down shouldn't be greyed out anymore.

Answers

Categories