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.
Go to Solution.
@Sravan_Kumar - Don't Use Sum and Lookup, Because you have common dimension.
Just simply hard core the formula. it works.
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.
Find the below Screen shot.
Check your dimension and if possible send the screen shot of blueprint and list hierarchy
I want the Level 3 total only in the final module.
Please tell me, where I need to edit.
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
But is it any need of using new Dimension in Target Module...?
Thanks so much friend @Sorna Raja Prabhu so for your generous help.
My project is needed in that way.
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!
Thanks so much @kavinkumar.