Unable to find the Maximum value in a string

[Anonymous]

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

[sunny_talwar]

What object are you using here?

[Anonymous]

Pivot Table, and there are couple of Expressions associated with the output of max value.

[sunny_talwar]

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

[Anonymous]

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.

[sunny_talwar · Accepted solution]

May be this

=If(vVar = 1, Child, Aggr(If(SubField(Child, '.', 2) = Max(TOTAL <Parent> SubField(Child, '.', 2)), Child), Child, Parent))

[Anonymous]

I think this should work. Let me test and get back to you!! Thanks