I have a crosstab that does weekly averages, ranges, maximums, minimums and totals using "calculated members".
Example: I compute maximum with this formula: local numbervar i; local numbervar max := GridValueAt(CurrentRowIndex,0,0); for i := 1 to ...