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

 

 

 

 

Best Answers

  • naushad786
    Answer ✓

    Hi @Star ,

     

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

     

    Hope, it will help you.

     

    Thanks,

    Naushad

  • prabhu
    Answer ✓

    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.

  • Star
    Answer ✓

    @prabhu 

    Yes, it indeed worked.  Thanks 🙂

    Star_0-1584530806812.png

    Star_1-1584530902475.png

     

     

     

     

Answers

  • 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

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