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:
Data Sheet: its a Data Sheet.
A Summary Sheet has all of the behaviors and capabilities of a 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 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 'Build Expressions' button.
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.
Observe that the field values are displayed, in the 'New Field Preview'.
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:
Last updated