Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
May be a set expression like this in your expression
{<Parent = p(Child), Child>+<Child = p(Child)>}
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.