# Summary Sheet

A Summary Sheet shows a grid of summarized numeric values for each category in a table. The table has one row for each unique value, or category, in the first (key) column, and any number of numeric columns can be summed, averaged, or counted correspondingly. A Summary Sheet is basically a textual version of a bar chart. The rows of the grid can be sorted, or the columns rearranged; and the category for the table's focus row is shown in the top row. Learn about each Summary Sheet feature below:

![](https://1916279106-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-Lf5YcsNySU3Og8Ms9rA%2F-Lf5ZCyAZIyYzxDLDEKS%2F-Lf5_-KGULzH0lemmAOc%2FsimpleSS.png?generation=1558109755961707\&alt=media)

**Data Sheet:** its a Data Sheet.

* A Summary Sheet has all of the behaviors and capabilities of a [Data Sheet](https://help.advizorsolutions.com/v7.2+/charts-and-visual-discovery/charts-overview/data-sheet). This includes a focus line, which is off by default. You can show a Summary Sheet in reduced representation, although this may not be very interesting. A Summary Sheet does not use the current coloring, however; it is drawn in the current Foreground color, which you can change as an individual preference from the [Chart Colors](https://github.com/asisupport/ADVIZOR-Help-V2/tree/26d8b1cd60d32eb467f6cec93d8a5eda808ecb7d/main-menu/tools-menu.md) dialog.

  **From:** Advanced Property "Display Focus".

**Data:** a categorical field and any number of measures.

* A Summary Sheet shows a set of measures, with aggregations chosen by you, for a single categorical field. It is thus like a textual clustered bar chart. Aggregations are Count, Sum, Average, Ratio, Cumulative Sum, and Cumulative Count.

  **From:** Chart Toolbar "Configure Data".

**Overall:** column total for each numeric measure.

* The last row has the category name "Overall", and gives the column total for each measure using the aggregation operation for that column.

**Export:** write table to a file.

* Write the currently selected rows to a table. Only the fields shown by the chart are exported. This gives you a way to choose which fields in a large table to export.

  **From:** Chart Toolbar "Export Data..."

**See also:**

* [Inserting a Summary Sheet](https://help.advizorsolutions.com/v7.2+/charts-and-visual-discovery/charts-overview/summary-sheet/inserting-a-summary-sheet) 
* [Tool bar controls](https://help.advizorsolutions.com/v7.2+/charts-and-visual-discovery/charts-overview/summary-sheet/summary-sheet-toolbar)
* [Property Explorer](https://help.advizorsolutions.com/v7.2+/using-advizor/author-ribbon/configure-charts/property-explorer) 
* [Visual Discovery](https://help.advizorsolutions.com/v7.2+/charts-and-visual-discovery/visual-discovery)