To
calculate totals and subtotals for the data in the table viewer:
-
Select
Data
Totals from the main menu bar.
-
Select
the totals and subtotals that you want to create:
Fields for the Totals Dialog Box
|
|
|
|
|
|
Calculates subtotals for each row,
appearing in the rightmost column for each member of the outside hierarchy.
|
Enabled when two or more hierarchies
are assigned as columns.
|
|
|
Calculates subtotals for each column,
appearing in the bottom row for each member of the outside hierarchy.
|
Enabled when two or more hierarchies
are assigned as rows.
|
|
|
Calculates totals for each row,
appearing in the rightmost column.
|
Enabled when one or more hierarchies
are assigned as columns.
|
|
|
Calculates totals for each column,
appearing in the bottom row.
|
Enabled when one or more hierarchies
are assigned as rows.
|
-
Select
where the totals are displayed:
places row totals at
the top, and column totals on the left.
places row totals at
the bottom, and column totals on the right.
-
Select
the values that are used to calculate the totals:
specifies that the
values which are currently displayed in the table viewer are used
for the totals.
specifies that the
totals use all of the values from the query to calculate
the totals. Filters and drill actions do not affect the totals.
-
(Optional)
If you selected
Parent totals, select whether
to include itemized totals. Check
Itemize values across
hierarchies to display itemized totals for each hierarchy
member.
-
Click
OK to apply your changes and return to the main SAS
Web OLAP Viewer page.
The following
image shows a table with totals and subtotals for the column axis
and totals for the row axis.
