Methods and systems for recursively generating pivot tables

A system for recursively generating pivot tables, comprising:

• a data processing system having a pivot table generation module and a user interface module, the data processing system further comprising
• a memory storing processor-executable instructions;
• and
• a processor configured to execute the processor-executable instructions to:
• receive a first request to generate a first pivot table from a data set including a plurality of entries corresponding to a plurality of dimensions and a plurality of metrics, the request identifying a first dimension of the plurality of dimensions and at least one metric of the plurality of metrics;
• generate the first pivot table including a first set of results, each result of the first set of results including a first plurality of values corresponding to the first dimension and the at least one metric identified in the first request;
• provide, for display on a user interface, the generated first pivot table, each value of the first dimension associated with a corresponding actionable object for further filtering the data set;
• receive an action on at least one actionable object corresponding to a particular value of the first dimension;
• identify, from the first set of results, one or more results corresponding to the particular value of the first dimension;
• receive a second request to generate a second pivot table from the results corresponding to the particular value of the first dimension, the second request identifying a second dimension of the plurality of dimensions and at least one metric of the plurality of metrics;
• generate, from the identified results corresponding to the particular value of the first dimension, the second pivot table including a second set of results, each result of the second set of results including a second plurality of dimension values corresponding to the second dimension and the at least one metric identified in the second request;
• and
• provide, for display on the user interface, the second pivot table, each dimension value of the second dimension associated with a corresponding actionable object for further filtering the data set.

A computer-readable storage medium having instructions to provide information via a computer network, the instructions comprising instructions to:

• receive a first request to generate a first pivot table from a data set including a plurality of entries corresponding to a plurality of dimensions and a plurality of metrics, the request identifying a first dimension of the plurality of dimensions and at least one metric of the plurality of metrics;
• generate the first pivot table including a first set of results, each result of the first set of results including a first plurality of values corresponding to the first dimension and the at least one metric identified in the first request;
• provide, for display on a user interface, the generated first pivot table, each value of the first dimension associated with a corresponding actionable object for further filtering the data set;
• receive an action on at least one actionable object corresponding to a particular value of the first dimension;
• identify, from the first set of results, one or more results corresponding to the particular value of the first dimension;
• receive a second request to generate a second pivot table from the results corresponding to the particular value of the first dimension, the second request identifying a second dimension of the plurality of dimensions and at least one metric of the plurality of metrics;
• generate, from the identified results corresponding to the particular value of the first dimension, the second pivot table including a second set of results, each result of the second set of results including a second plurality of dimension values corresponding to the second dimension and the at least one metric identified in the second request;
• and
• provide, for display on the user interface, the second pivot table, each dimension value of the second dimension associated with a corresponding actionable object for further filtering the data set.