Highlighted
Regular Contributor

CODE, PARENT AND 'GRANDPARENT' FUNCTION

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?

 

Star_1-1584513322058.png

 

Star_2-1584513374393.png

 

 

 

 

5 REPLIES 5
Highlighted
Frequent Contributor

Re: CODE, PARENT AND 'GRANDPARENT' FUNCTION

Hi @Star ,

 

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

 

Hope, it will help you.

 

Thanks,

Naushad

Highlighted
Super Contributor

Re: CODE, PARENT AND 'GRANDPARENT' FUNCTION

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

Sorna Raja Prabhu
Highlighted
Regular Contributor

Re: CODE, PARENT AND 'GRANDPARENT' FUNCTION

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

Re: CODE, PARENT AND 'GRANDPARENT' FUNCTION

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.

 

 

 

Capture10.JPGCapture11.JPG

 

You can share your error when you are following this approach.

Sorna Raja Prabhu
Highlighted
Regular Contributor

Re: CODE, PARENT AND 'GRANDPARENT' FUNCTION

@Sorna Raja Prabhu 

Yes, it indeed worked.  Thanks 🙂

Star_0-1584530806812.png

Star_1-1584530902475.png