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 am trying to create a new Anaplan Connection using the excel plugin. It asks me for an environment and I chose the default one (https://us1a.app.anaplan.com). It then asks me to connect with my Anaplan account but it just says : ———— The Anaplan server returned an error: Authentication Failure. If you're unsuccessful…
It's now possible to use the additional insights to have dynamic filters, however the columns in the table are fixed widths. It's quite unfortunate that the ability is added, but the layout isn't dynamic. I understand that a report is more fixed, but adding dynamic columns would really help make the management report…
There was an error rendering this rich post.
