calculated dimension

[Anonymous]

value

Range	Count
0-1	2	89
0-1	3	100

Is there a way to only display row 2 in a pivot table?

IF(Count = max(Count),ONLY(Range))  does not give the desired result. I just want to display row number 2 only.

Thanks

[tresB · Accepted solution]

Try expression like:

=AGGR (IF(Count = max(total Count), Range) , Range, Count)

And the check 'Suppress When Value is Null' in the dimension tab