Forum Discussion

SaiKumarReddy's avatar
SaiKumarReddy
New Contributor II
2 years ago

Show L1,L2 in Cube View

A#Cash.TreeDescendantsInclusive.Where(Text8 = L1).
I have used the above formula to display only level1 members of one account but now I want to like to display level1 members along with the parent members of L1.
Help me out in reframing the above formula.
Thank you.

  • JackLacava's avatar
    JackLacava
    Honored Contributor

    Going "up" a tree is typically a bad idea, for the simple fact that the system must work on the assumption that there might be more than one parent. You can try appending .Parents but it might return multiple ones.

    A better idea is probably to start your filtering directly at the parent level, and then look at the descendants of the selected parents. This might have the side-effect of having to edit the Text8 property on fewer members, which is always a good idea.