CODE, PARENT AND 'GRANDPARENT' FUNCTION

[Star]

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?

[naushad786 · Accepted solution]

Hi @Star ,

You can use PARENT(PARENT(ITEM('G3 Location'))). 

Hope, it will help you.

Thanks,

Naushad

[Sorna Raja Prabhu]

Hi @Star,

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.

Thanks,

Sorna Raja Prabhu

[Star]

@Sorna Raja Prabhu
Suggestion 1 works perfectly.
Suggestion 2 would require the 'Applies to' to be Country List rather than Location list, right?

[Sorna Raja Prabhu · Accepted solution]

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.

[Star · Accepted solution]

@Sorna Raja Prabhu 

Yes, it indeed worked.  Thanks 🙂