XPAC Reference Guide

How do I display totals?

How do I display totals?
How do I display totals?

You can display totals of measures in your pivot view.

To display a total as the last row in a table:

1.	Drag & drop a field from the Attributes pane to the Rows shelf. Labels for the field display along the left side of the Pivot Grid.

2.	Drag & drop a field from the Measures pane to the Label field on the Encodings card. The data for each attribute displays as a new column in the Pivot Grid.

3.	Right-click the attribute on the Rows shelf and select Display totals. A row labelled Total displays as the last row in the table and the aggregated value for the measure in the data column.

To display a total as the last column in a table:

1.	Drag & drop a field from the Attributes pane to the Columns shelf. Labels for the field display along the top of the Pivot Grid.

2.	Drag & drop a field from the Measures pane to the Label field on the Encodings card. The data for each attribute displays as a new row in the Pivot Grid.

3.	Right-click the attribute on the Columns shelf and select Display totals. A column labelled Total displays as the last column in the table and the aggregated value for the measure in the data row.