×

Dynamically filtering aggregate reports based on values resulting from one or more previously applied filters

  • US 9,195,728 B2
  • Filed: 09/30/2010
  • Issued: 11/24/2015
  • Est. Priority Date: 06/21/2005
  • Status: Active Grant
First Claim
Patent Images

1. A computer-implemented method for dynamically filtering visible values in a spreadsheet, comprising:

  • maintaining a plurality of filters to be applied in a designated order to the spreadsheet, the spreadsheet comprising a plurality of cells;

    applying, by the computer, a first filter to a first set of cell values in the spreadsheet;

    generating a second set of cell values by evaluating the first set of cell values, the second set of cell values hiding a first excluded cell value from the first set of cell values based on the first filter;

    applying a second filter to the second set of cell values;

    generating a third set of cell values by evaluating the second set of cell values, the third set of cell values hiding a second excluded cell value from the second set of cell values based on the second filter, the first and second excluded cell values being hidden by collapsing one or more details comprising the first and second excluded cell values in the first set of cell values and the second set of cell values;

    generating an aggregate cell value by evaluating only the third set of cell values;

    determining whether there is a next filter from the plurality of filters yet to be applied to an aggregate report comprising the aggregate cell value; and

    in response to determining that there is a next filter yet to be applied, delaying applying the next filter to the aggregate report until a same level of detail is displayed for each of the plurality of cells in the spreadsheet.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×