I have data similar like this.
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.
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