I know we can always add a new column referencing a function, such as:
timeTable.Data = functionOf(timeTable.ExistingVar);
But was interested in something that'd be done automatically based on content of all other table columns and transparently when a new line is entered ...
Something along the lines of a column that automatically computes best/worst performers (max/min/etc) on all the other columns & does a set of operations based on its previous values ... say something like this:
newValue = previousValue + max(values in columns 1:10) on the last line.