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.
There was an error rendering this rich post.
Hi all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
