Display only the highest value row while grouping dimension

[Santes8]

I am looking to group dimension values and display only the highest value row

From the attached example, how can I display only the row with 'InsurancePolicy...' equaling 2 by grouping the 'Total Charges' ?

Note, this is a very small subset example of a metric that would be used on a much larger scale.

Thank you!

[JordyWegman]

Hi Santes,

Do you want the highest value per dimension value? Or just the highest value with the corresponding dimension?

First question will result in multiple rows, and the second will result in just one row.

Jordy

Climber

[Santes8]

Hi Jordy,
I am looking to display the entire row based on the the highest number in the one dimension, grouping another dimension.
(I would like it to look for all 99s in Total Charges then only display the entire row with the highest number in Insurance Policy...)
Thanks!