Hi
CODE(ITEM('G3 Location')) and PARENT(ITEM('G3 Location')) were defined for the following Code and Country results. Is there a 'grandparent' function that can be used to display Region?
Hi @Star ,
You can use PARENT(PARENT(ITEM('G3 Location'))).
Hope, it will help you.
Thanks,
Naushad
Hi @Star,
Suggestion 2 would require the 'Applies to' to be Country List rather than Location list, right?
No, You Don't Want to Change anything. it Works.
You can share your error when you are following this approach.
@prabhu
Yes, it indeed worked. Thanks 🙂
There is no Grand Parent Function.
You can use in 2 ways.
1. PARENT(PARENT(ITEM('G3 Location')))
2. PARENT(Country) Country -> Line Item
Both Result the Same Output.
Sorna Raja Prabhu
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.