This module consists of E2 Employee# list and 2 line items, one is to filter out the employee whose department needed to be changed. When I applied the filter and enable it all the unchecked line Items vanished. what I need is, when all is unchecked the list should appear and when one list member is checked it should filter out every other list member and only show the checked one. What are the ways I can achieve this? Help me with hints or suggestions. Thanks in advance!
Hi @SoumyadipKuila
You can create new line item just for filtering.
To put formula in this line item please do the following: 1) Ensure you have top level element in Employee hierarchy (Let's call it "AAA") 2) Apply summary method "any" for "department change?" line item 3) Write formula 'department change?' or not 'department change?'[SELECT: 'E2 Employee#'.AAA]
Then apply filter for this line item. You may also consider "Formula" or "Any" summary methods for showing E1 level elements.
https://help.anaplan.com/create-a-filter-in-a-module-9321cb3e-284d-4014-a855-1c62f0a33b36
Hi, I was hoping to get some help with this situation, where I am trying to take a list to list mapping on the left and get an output similar to the right, but the main idea is i want to be able to make the selected item (format: list), the dimension of a target module and reverse map the original source list as a list…
Hello everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New → New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, no…
Why in my model output is blank, after send explainability data.
