Chart level grouping

[krish2459]

Hi,

I'm having the attached data.

I need to show unique Id with minumum distance.

Please refer to the "desired out" sheet excatly what I need.

Sheet1 having the sample data.

Thanks,

Krish

[joaopaulo_delco · Accepted solution]

Hi @krish2459 !

         You have to use the FirstSortedValue() function on your "Nearest Locality" column with the expression below:

=FirstSortedValue([Nearest Locality], Distance)

and also change the column "Distance" to measure Min(Distance) 

See the app attached.