Generating a database query to dynamically aggregate rows of a data set

An apparatus for generating a database query to dynamically aggregate rows of a data set, the apparatus comprising a computer processor, a computer memory operatively coupled to the computer processor, the computer memory having disposed within it computer program instructions that, when executed by the computer processor, cause the apparatus to carry out the steps of:

• determining a hierarchical relationship between a first column and a second column within a spreadsheet structure, wherein the first column and the second column comprise rows of the data set;
• receiving a calculation for a third column within the spreadsheet structure;
• determining that the third column is on a same hierarchical level as the first column;
• and
• in response to determining that the third column is on the same hierarchical level as the first column, generating the database query aggregating a plurality of rows of the data set based on the calculation for the third column and the hierarchical relationship between the first column and the second column.

A computer program product for generating a database query to dynamically aggregate rows of a data set, the computer program product disposed upon a computer readable medium, the computer program product comprising computer program instructions that, when executed, cause a computer to carry out the steps of:

• determining a hierarchical relationship between a first column and a second column within a spreadsheet structure, wherein the first column and the second column comprise rows of the data set;
• receiving a calculation for a third column within the spreadsheet structure;
• determining that the third column is on a same hierarchical level as the first column;
• and
• in response to determining that the third column is on the same hierarchical level as the first column, generating the database query aggregating a plurality of rows of the data set based on the calculation for the third column and the hierarchical relationship between the first column and the second column.