Sum based on Parent in Hierarchical List
I have a hierarchy of lists, L1>L2>L3. My module is dimentioned by L3 and has two line items, Input value and Input %. Input Value is entered by user. Input % = Input Value/Sum of Input Values for all list items of L3 under a L2 list item.
How can I calculate this sum, as it is the sum of all items in L3 under L2 a list item. Please let me know, thanks.