Finding value of column y at max value of column XI want to find the maxium value in column "Power (dBm)" grouped by BarID, ChipID.
And use that to find the corresponding value in column "Wavelength (nm)" to give me a summary table showing the value of maxium power and what value of wavelngth it occurs at grouped by BarID, ChipID etc.

AnalyticsData Table