How to sum members based on Smartlist selection
Summary
How to sum members based on Smartlist selectionContent
Hi,
My requirement is I need to sum the entity members based on Smartlist selection.
Example: My smartlist A has two members A11 and A12 and my Entity has 5 members. For all 3 Entities that has Smartlist A11, I need to sum of all 3 Entities for smartlist A11 under one placeholder members in Account dimension say X1. What will my syntax
If (Smartlist==A11)
X1= ?
Thanks,
0