# US 9,436,671 B2 · Displaying multiple row and column header areas in a summary table > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 9,436,671 B2 - Document ID: US9436671B2 - Status: Granted - Kind: B2 - Application number: 13/668,931 - Filed: 2012-11-05 - Published: 2013-03-14 - Granted: 2016-09-06 - Earliest claimed: 2009-02-11 - Assignees: Microsoft Technology Licensing, LLC - Applicants: Microsoft Technology Licensing, LLC - Inventors: Allan Folting - Web page: https://patentgrep.com/patent/US9436671B2 ## CPC - G06F 40/18: of spreadsheets (form-filling G06F40/174) - G06F 40/106: Display of layout of documents; Previewing - G06F 40/177: of tables; using ruled lines - G06F 3/0482: Interaction with lists of selectable items, e.g. menus - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) ## 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. ## Claims ### Claim 1 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. ### Claim 2 (depends on 1) The computer-implemented method of claim 1, wherein an aggregate label is displayed in a row header area of the plurality of row header areas, such that the row data field values for data fields selected via the row header data field selection are summarized in a single row. ### Claim 3 (depends on 2) The computer-implemented method of claim 2, wherein operations performed in regard to the row header area of the plurality of row header areas in the summary table affect the rendering of the plurality of column header areas. ### Claim 4 (depends on 1) The computer-implemented method of claim 1, wherein an aggregate label is displayed in a column header area of the plurality of column header areas, such that the column data field values for data fields selected via the column header data field selection are summarized in a single column. ### Claim 5 (depends on 4) The computer-implemented method of claim 4, wherein operations performed in regard to the column header area of the plurality of column header areas in the summary table affect the rendering of the plurality of row header areas. ### Claim 6 (depends on 1) The computer-implemented method of claim 1, wherein rendering to the display device the plurality of column header areas and the plurality of row header areas in the summary table comprises rendering to the display device the plurality of column header areas and the plurality of row header areas in the summary table to the display device by a spreadsheet program. ### Claim 7 (depends on 1) The computer-implemented method of claim 1, wherein operations performed to an entirety of the summary table affect the rendering of both the plurality of row header areas and the plurality of column header areas. ### Claim 8 (depends on 1) The computer-implemented method of claim 1, wherein the plurality of row header areas are adjacent to each other. ### Claim 9 (depends on 1) The computer-implemented method of claim 1, wherein the plurality of column header areas are adjacent to each other. ### Claim 10 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. ### Claim 11 (depends on 10) The optical disk, the magnetic storage device, or the solid state storage device of claim 10, wherein an aggregate label is displayed in a row header area of the plurality of row header areas, such that the row data field values associated with the plurality of row header areas are summarized in a single row. ### Claim 12 (depends on 10) The optical disk, the magnetic storage device, or the solid state storage device of claim 10, wherein an aggregate label is displayed in a column header area of the plurality of column header areas, such that the column data field values associated with the plurality of column header areas are summarized in a single column. ### Claim 13 (depends on 10) The optical disk, the magnetic storage device, or the solid state storage device of claim 10, wherein rendering the summary table to the display device comprises rendering the summary table to the display device by a spreadsheet program. ### Claim 14 (depends on 10) The optical disk, the magnetic storage device, or the solid state storage device of claim 10, wherein operations performed to an entirety of the summary table affect the display of both the plurality of row header areas and the plurality of column header areas. ### Claim 15 (depends on 10) The optical disk, the magnetic storage device, or the solid state storage device of claim 10, wherein the plurality of row header areas are adjacent to each other. ### Claim 16 (depends on 10) The optical disk, the magnetic storage device, or the solid state storage device of claim 10, wherein the plurality of column header areas are adjacent to each other. ### Claim 17 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. ### Claim 18 (depends on 17) The computer of claim 17, wherein an aggregate label is displayed in a row header area of the plurality of row header areas, such that the row data field values associated with the plurality of row header areas are summarized in a single row. ### Claim 19 (depends on 17) The computer of claim 17, wherein the plurality of row header areas are adjacent to each other. ### Claim 20 (depends on 17) The computer of claim 17, wherein the plurality of column header areas are adjacent to each other.