CODE, PARENT AND 'GRANDPARENT' FUNCTION

Options
Star
Star
in Modeling

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

 

 

 

 

Tagged:

Best Answers

  • naushad786
    naushad786
    Answer ✓
    Options

    Hi @Star ,

     

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

     

    Hope, it will help you.

     

    Thanks,

    Naushad

  • prabhu
    prabhu
    Answer ✓
    Options

    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
    Star
    Answer ✓
    Options

    @prabhu 

    Yes, it indeed worked.  Thanks 🙂

    Star_0-1584530806812.png

    Star_1-1584530902475.png

     

     

     

     

Answers

  • prabhu
    prabhu
    Options

    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
    Star
    Options
    @prabhu
    Suggestion 1 works perfectly.
    Suggestion 2 would require the 'Applies to' to be Country List rather than Location list, right?

Categories