Set Analysis as a Calculated Dimension Displaying Possible

[mellerbeck]

Given

LOAD * INLINE [

    Parent, Child

    1, A

    1, B

    1, C

    1, D

    A, 2

    A, 3

    A, 4

    A, 5

];

If Child A is selected, Parent 1 is possible. I would like a chart that can show that A is a parent as well and its children are 2,3,4,5.

Something like

=aggr(Only({<Parent=P(Child)>} Parent),Child)

But I haven't quite grokked it yet

Thanks for any thoughts on this one!

[sunny_talwar]

May be a set expression like this in your expression

{<Parent = p(Child), Child>+<Child = p(Child)>}

[mellerbeck · Accepted solution]

I ended up adding a qty value to my test and then did Child as the Dimension and

=Sum({1<Parent=P(Child)>} qty) as the expression.