Patent ID: 8185817

Claim:
A system for creating calculations within grouped aggregate views of spreadsheets: a computing device comprising: a grouped aggregate view feature which enables a user to create a grouped aggregate view of data; a calculation feature which enables the user to create one or more calculations for the grouped aggregate view of data, the one or more calculations being based upon references to data in the grouped aggregate view, wherein the references to data in the grouped aggregate view include at least one relative reference to data and at least one absolute reference to data, the at least one relative reference takes into account its own location to determine which data to provide, the at least one absolute reference provides data at an absolute-specified location, wherein the calculation feature allows the user to select a first cell in which to place a respective one of the calculations, and also allows the user to select a second cell to reference as part of the respective one of the calculations; and a toggle feature which allows the user to toggle between a list of available references to data for the second cell that can be selected as part of the one or more calculations, the available references to data being related to the data in the grouped aggregate view.