Populate a Smart List with a Parent of a value from another Smart List
Summary: I have two Accounts, ProjectChild & ProjectParent. Both have Data Types of Smart List and both Smart Lists are referring to Dim members in the Entity Dimension.
SL_EntityL0 refers to Level 0 Entities and
SL_EntityL1 refers to Level 1 Entities.
Based on the value selected in Account ProjectChild from SL_EntityL0, I want to calculate the value for ProjectParent.
It should show the SmartList entry for the Parent of the member selected in ProjectChild
Does anybody have a calculation for this as I've tried and can only generate errors or incorrect answers :-(
I've also tried freeform text but I can't get that to work either
Tagged:
0