Inserting a Summary Sheet
Last updated
Last updated
A can be used to examine rolled-up or aggregated data for several measures tables based on a particular categorical dimension.
In the Author Ribbon, click on the "Add New Chart" button (under Pick Charts) and click Summary Sheet.
If the Data Configuration form is not already showing, click the configuration button to open the Data Configuration window. If the Data Table shown is not the one you want, use the drop-down list to select the right one.
From the Primary Field pulldown list, select the field that will serve as the focus of the Summary Sheet.
Select all Summary Fields to be included in the Summary Sheet by checking the boxes next to the field names. To select all fields, click the Check All button (conversely, click Uncheck All to de-select all fields). A checkmark indicates the field has been selected.
Choose the aggregation Calculation for each Summary Field from the drop-down list. If you choose Ratio, then also choose a Denominator field from the drop-down list in the last column.
Click OK. The summary sheet displays the data you selected in a columnar format.
See also:
