Patent ID: 8510645

Claim:
A computer-implemented method of updating a display of a tabular representation, said method comprising the steps of: (i) generating a tabular representation of a set of data, said representation comprising a plurality of columns containing the set of data; (ii) grouping the set of data by grouping a plurality of identical rows in at least one column to form a plurality of groups in each column of the tabular representation, said grouping being based on data in at least one column of the tabular representation; (iii) generating an aggregate column in the tabular representation comprising aggregate data derived from an aggregate function applied to at least some of the set of data based on the grouping of the data in an existing column; (iv) displaying the tabular representation with the aggregate column of data; (v) moving the aggregate column in the tabular representation; and (vi) updating the display of the tabular representation, wherein vertically adjacent cells within the moved aggregate column are grouped according to grouping of vertically left adjacent data within a second column of the tabular representation adjacent the moved aggregate column, and wherein the aggregate data in the moved aggregate column is determined by applying the aggregate function to at least some of the set of data in the existing column selected according to the grouping of the data in the second column adjacent the moved aggregate column to calculate an aggregate value for each group in the aggregate column when the aggregate column is moved, wherein the vertically left adjacent data within the second column corresponds to the set of data in the existing column, wherein at least first and second columns of the tabular representation display a grouping hierarchy relationship, so that the first column is displayed to the left of the second column and occupies a higher position in the hierarchy than the second column.