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.
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!
@Sravan_Kumar - Don't Use Sum and Lookup, Because you have common dimension.
Just simply **** the formula. it works.
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 -
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.
Original Module:
Final Module:
@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.
Thanks so much friend @prabhu so for your generous help.
My project is needed in that way.
The data I'm trying to import is as follows Parent-Code A B A C B D C D D E I want to generate the following list from this data: L1 L2 L3 L4 A A-B A-B-D A-B-D-E A A-C A-C-D A-C-D-E You can create up to L3.However, L4 has multiple parents for one row of data When I try to create L4 from D-E, only one list row is generated…
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
