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