From the available measures in Row Area and Column Area, in Aggregate On, select the measures for which to display grand totals.
For each selected measure, in Function, choose a function from the list to calculate the grand total, as shown in Figure 4-5.
If you deselect On Detail Row, Data Analyzer uses the cross-tab display values to calculate grand totals.
If you select On Detail Row, Data Analyzer uses the detail row values in the data source to calculate grand totals.
From the measures in Row Area and Column Area, in Aggregate On, select measures for which to display subtotals.
In Function, for each selected measure, choose a function from the list to calculate the subtotal.
If you deselect On Detail Row, Data Analyzer uses the cross-tab display values to calculate subtotals.
If you select On Detail Row, Data Analyzer uses the detail row values in the data source to calculate subtotals.Data Analyzer displays the specified grand totals and subtotals. For example, Figure 4-6 displays the average sale amounts, based on detail rows in the data source, in the Average Sale Amount row, and the sum grand totals in the Grand Total column. Also, the figure displays first-quarter and second-quarter subtotals in the Planes, Ships, and Trains columns.
|
|
Copyright Actuate Corporation 2012 |