Adding a common line item associated with a single list item
Hello all,
Can you please advice how to add "line item associated with a single list items"?
In the attached screen shot,
•MU approved/agreed and
•GS approved
are list items and I have created a nested dimension in module, such that the line item is common for these list items.
Now I need to add, the columns highlighted in yellow but I am unable to get it.
Can you please guide on it.
Thank you,
harshitha N.
Best Answer
-
Thank you for the reply @Misbah!
To achieve the desired results, I created another module and in that module pulled out line items "TTL GC (curr month)" for list items "MU approved/agreed" and "GS approved" by using SELECT functionality and this sorted my issue. I have attached the screenshot of what action I have taken.
0
Answers
-
You can not have a line item associated with list items. Line items are applied to the entire list (or in other words dimension). There will be some empty cells that we call Sparsity in Anaplan language, that is fair but there is no slice and dice in such cases.
If it is for reporting purpose then I would say consider using SHOW or HIDE options.
Thanks,
Misbah
Miz Logix
0 -
Glad that you figured it out but I would advise not to use SELECT. Instead you can use LOOKUP to avoid getting into scalability issues.
Thanks,
Misbah
Miz Logix
0 -
I did try using Lookup but it did not give me the results. For any similar issues in future shall use the lookup functionality.0
