Displaying multiple row and column header areas in a summary table
AssigneeMicrosoft Technology Licensing, LLC
InventorAllan Folting
Life of this patent
Estimating the term…
Abstract
A data analysis program receives a selection of data fields defining multiple row header areas and/or multiple column header areas for display in a summary table. Data is read from a data source containing values for the data fields and transformed into summary level data for building the summary table. A display is rendered in the summary table for each of the multiple row header areas and column header areas defined, with the row header areas being displayed vertically adjacent to one another and the column header areas being displayed horizontally adjacent to one another.
Claims20
A computer-implemented method for displaying a summary table, the method comprising:
- receiving a column header data field selection associated with a plurality of column header areas of the summary table;
- receiving a row header data field selection associated with a plurality of row header areas of the summary table, the row header data field selection having at least one data field different from the column header data field selection;
- reading data from a data source, the data containing column data field values for data fields selected via the column header data field selection and row data field values for data fields selected via the row header data field selection;
- transforming the data from the data source to summary level data for rendering the summary table;
- and
- rendering to a display device the plurality of column header areas and the plurality of row header areas in the summary table, the plurality of column header areas comprising a distinct set of columns labeled with the column data field values from the column header data field selection, and the plurality of row header areas comprising a distinct set of rows labeled with the row data field values from the row data field selection.
An optical disk, a magnetic storage device, or a solid state storage device having computer executable instructions stored thereon that, when executed by a computer, cause the computer to:
- receive a selection of data fields associated with a plurality of row header areas of a summary table;
- receive a selection of data fields associated with a plurality of column header areas of the summary table, the selection of data fields associated with the plurality of row header areas having at least one data field different from the selection of data fields associated with the plurality of column header areas;
- read data from a data source, the data containing column data field values for data fields selected via the selection of data fields associated with the plurality of column header areas and row data field values for data fields selected via the selection of data fields associated with the plurality of row header areas;
- transform the data from the data source to summary level data for rendering the summary table;
- and
- render to a display device the plurality of row header areas and the plurality of column header areas in the summary table, the plurality of row header areas comprising a distinct set of rows labeled with the row data field values and the plurality of column header areas comprising a distinct set of columns labeled with the column data field values.
A computer, comprising:
- a processor;
- and
- a computer-readable storage medium in communication with the processor, the computer-readable storage medium comprising computer-executable instructions storage thereupon which, when executed by the processor, cause the processor to:
- receive a selection of data fields associated with a plurality of row header areas of a summary table;
- receive a selection of data fields associated with a plurality of column header areas of the summary table, the selection of data fields associated with the plurality of row header areas having at least one data field different from the selection of data fields associated with the plurality of column header areas;
- read data from a data source, the data containing column data field values for data fields selected via the selection of data fields associated with the plurality of column header areas and row data field values for data fields selected via the selection of data fields associated with the plurality of row header areas;
- transform the data from the data source to summary level data for rendering the summary table;
- and
- render to a display device the plurality of row header areas and the plurality of column header areas in the summary table, the plurality of row header areas comprising a distinct set of rows labeled with the row data field values and the plurality of column header areas comprising a distinct set of columns labeled with the column data field values.
Dependencies are inferred from the claim text.