My Table looks like below
I need to pick up the first record for Resp and also the first record for Resol. i tried creating calculated field but no luck.In some cases Resp70% is first record and in some cases we have resp 80% is first record. Please someone help.
So you need the first index and not the min or max value, correct? Do you have the option of changing your data source table to add an index value?