Help Post ---- Import Parent Level data

Dear Friends,

 

I am in urgent need, to find the Parent level total in a different module.

But I am unable to do so. 

SUM, LOOKUP didn't work mentioning issues.

Kindly help me, I am in  really dire need.

 

Sravan_Kumar_0-1586412920729.png

Sravan_Kumar_1-1586413050312.png

 

 

Best Answer

  • kavinkumar
    Answer ✓

    HI @Sravan_Kumar,

    Create another line item with 'List New' as format in 'Module Tests - Copy' module and put this formula. FINDITEM('List New',Prodt Text). Then by using SUM function, try to achieve the data in your target module. 

    Hope it helps! 

Answers

  • @Sravan_Kumar  - Don't Use Sum and Lookup, Because you have common dimension.

     

    Just simply **** the formula. it works.

     

    Capture.JPGCapture1.JPG

  • Hi @prabhu.

    Did it work for you if have multiple child?

    I tried it, it didn't work for me.

    It is returning full total, not total as: L3A, L3B, L3C, L3D, L3E... individually.

    It returned total of L3.

    Please let me know, if I am wrong.

    Sravan_Kumar_0-1586413910358.png

     

    Sravan_Kumar_1-1586413940961.png

     

  • @Sravan_Kumar - 

     

    Find the below Screen shot.

     

    Capture.JPGCapture2.JPG

     

     

     

    Check your dimension and if possible send the screen shot of  blueprint and list hierarchy

  • Hi @prabhu.

    I want the Level 3 total only in the final module.

    Please tell me, where I need to edit.

     

     

    Original Module: 

    Sravan_Kumar_0-1586415349675.png

     

     

    Final Module:

    Sravan_Kumar_1-1586415395506.png

     

    Sravan_Kumar_2-1586415427760.png

     

  • @Sravan_Kumar,

     

    You are using different dimension(Which is not a part of Hierarchy dimension in Source Module) in target module.

     

    If you replace the dimension from List New(Flat list) to Level 3 Dimension 

     

    it works.

     

     

    But is it any need of using new Dimension in Target Module...?

  • Thanks so much @kavinkumar.

    It helped.

    Sravan_Kumar_0-1586418306462.png

     

  • Thanks so much friend @prabhu so for your generous help.

    My project is needed in that way.