Data analysis expressions

A computer-readable storage medium comprising instructions, that when executed by a processor, cause the processor to:

• receive input comprising a column definition of a particular column of a first spreadsheet table, wherein the input includes a data analysis expression based on at least one column of the first spreadsheet table other than the particular column and based on at least one column of a second spreadsheet table;
• determine a relationship between the first spreadsheet table and the second spreadsheet table based on the data analysis expression;
• and
• populate the particular column by executing the data analysis expression, wherein executing the data analysis expression for a particular row of the first spreadsheet table comprises:
• calculating a value of the data analysis expression based on first data in the particular row of the first spreadsheet table and second data retrieved from the second spreadsheet table based on a filter context associated with the particular row;
• and
• outputting the calculated value at a cell, wherein the cell is a member of the particular column and the particular row.

A computer system comprising:

• a memory;
• a data interface configured to receive data and to store the received data at a data table in an online analytical processing (OLAP) cube data structure at the memory;
• a pivot table module configured to generate a pivot table based on the data table;
• an analysis module configured to:
• receive a data analysis expression;
• and
• execute the data analysis expression, wherein executing the data analysis expression for a particular cell of the pivot table comprises:
• determining a row context associated with the particular cell;
• retrieving data associated with one or more rows of the data table corresponding to the row context from the OLAP cube data structure;
• calculating a value of the data analysis expression based on the retrieved data;
• and
• outputting the calculated value at the particular cell.