By doing the summary, I can get the max value of 100 in column D. I need to know which row in column D has the max value of 100. Then I want to get the value of column A in that row which has the max value of 100 in column D.
we know that the summary table and the source table (the original table) are linked by row states. If we select a row in the summary table, the corresponding rows in the source table will be selected. so maybe you can do something like this :
dt = current data table(); summary = dt << Summary( Group( summarycolumn ) ); n = nrows(summary); for (i=1, i summary << select rows (i); theRows = (dt << getselectedrows()); // now theRows has the rows for group i, do whatever you want with it. dt << clear select; )