Summary Sheet
Last updated
Last updated
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:
Data Sheet: its a Data Sheet.
A Summary Sheet has all of the behaviors and capabilities of a . 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 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:
