Help Post ---- Import Parent Level data

Sravan_Kumar
Community Boss

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
Sorna Raja Prabhu
Community Boss

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
Sravan_Kumar
Community Boss

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

 

Sorna Raja Prabhu
Community Boss

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
Sravan_Kumar
Community Boss

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

 

Sorna Raja Prabhu
Community Boss

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
Sravan_Kumar
Community Boss

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.

 

kavinkumar
Certified Master Anaplanner

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.
Sravan_Kumar
Community Boss

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

Thanks so much @kavinkumar.

It helped.

Sravan_Kumar_0-1586418306462.png