Help Post ---- Import Parent Level data

Highlighted
Super Contributor

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

 

 

8 REPLIES 8
Highlighted
Super Contributor

Re: Help Post ---- Import Parent Level data

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

 

Just simply hard core the formula. it works.

 

Capture.JPGCapture1.JPG

Sorna Raja Prabhu
Highlighted
Super Contributor

Re: Help Post ---- Import Parent Level data

Hi @Sorna Raja 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

 

Highlighted
Super Contributor

Re: Help Post ---- Import Parent Level data

@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

Sorna Raja Prabhu
Highlighted
Super Contributor

Re: Help Post ---- Import Parent Level data

Hi @Sorna Raja 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

 

Highlighted
Super Contributor

Re: Help Post ---- Import Parent Level data

@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...?

Sorna Raja Prabhu
Highlighted
Super Contributor

Re: Help Post ---- Import Parent Level data

Thanks so much friend @Sorna Raja Prabhu so for your generous help.

My project is needed in that way.

 

Highlighted
Master Anaplanner/Community Boss

Re: Help Post ---- Import Parent Level data

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! 

Regards,
Kavin.
Highlighted
Super Contributor

Re: Help Post ---- Import Parent Level data

Thanks so much @kavinkumar.

It helped.

Sravan_Kumar_0-1586418306462.png