Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have data similar like this.
Parent | Child | Amount |
---|---|---|
A | A.1 | 10 |
A | A.2 | 12 |
A | A.3 | 13 |
A | A.4 | 14 |
A | A.11 | 15 |
A | A.13 | 16 |
A | A.32 | 17 |
A | A.33 | 18 |
B | B.1 | 2 |
B | B.2 | 3 |
B | B.3 | 4 |
B | B.21 | 5 |
My requirement states that I have to show only these rows when a button is clicked. How can i achieve this.
I have tried MaxString, Aggr functions but dint help. Please advice.
Thanks,
SP
May be this
=If(vVar = 1, Child, Aggr(If(SubField(Child, '.', 2) = Max(TOTAL <Parent> SubField(Child, '.', 2)), Child), Child, Parent))
What object are you using here?
Pivot Table, and there are couple of Expressions associated with the output of max value.
Is Child one of the dimension? If it is.. then may be like this
If(vVar = 1, Child, Aggr(If(Child = MaxString(TOTAL <Parent> Child), Child), Child, Parent))
Here vVar is based off of the button and make sure to check 'Suppress When Value is Null' on the dimensions tab of the chart properties
I tried already this earlier but the problem with this expression is the Output will give A.4, because logically A.4 is greater than A.33.
May be this
=If(vVar = 1, Child, Aggr(If(SubField(Child, '.', 2) = Max(TOTAL <Parent> SubField(Child, '.', 2)), Child), Child, Parent))
I think this should work. Let me test and get back to you!! Thanks