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..."
Unique Counts: added as a calculation option.
Open the 'Customers.advm' demo project.
Select 'Author'.
Select the 'Customers' table, from the 'Table:' field list.
Enter 'IndustryCalculation' in the 'Calculated Field:' field.
Enter 'Industry' in the 'Type expression or drag primitive elements from the left panel:' field.
Select the 'Evaluate' button.
Select the 'OK' button.
Select the 'Add New Page' button, from the 'Design Pages' ribbon.
Enter 'Industry Calculation', in the 'Name:' field.
Select the 'OK' button.
Select the 'Use 'Add Charts' to start design of this page.' button.
Select the 'Summary Sheet' button.
Select 'IndustryCalculation', from the 'Primary Field:'.
Check the '# Customers' (Unique Count), 'Industry' (Unique Count), and 'State' (Unique Count) check boxes.
Select the 'OK' button.
Observe new Summary Sheet' with Unique Counts displayed.
See also:
Select the 'Build Expressions' button.
Observe that the field values are displayed, in the 'New Field Preview'.
