Summaries

Top  Previous  Next

There are 3 types of summaries you can display in an analysis table.

 

xls_summary_01

 

 

Summaries are displayed on the bottom of the table.  Group header summaries are displayed on each group's header level, and group footer summaries are displayed on each group's footer level.

 

To create a summary for a column, right click on the column header to bring up the summary context menu, select the summary type you require, and the numeric operation you require.

 

xls_summary_02

 

 

You can also create summary values by clicking on the Add button in the Summaries customization window.

 

summary_04

 

 

Select the column you want to create the summary for, the summary type, and the summary functions you want applied.

 

 

summary_05

 

 

In the above example, we chose to create 3 group summaries.  The summaries are then displayed at each grouping level.

 

summary_06

 

 

You will notice that the negative values are displayed strangely.  To change how the values are displayed, change Function label values for each summary item.  The first label will be used for all values.  If there is a second label, it will be used for negative values.  Thus, if we change our labels to the following:

 

summary_07

 

 

The summary values are displayed accordingly.

 

summary_09

 

 

 

To remove a summary, change the function type to (none) on the summaries customization panel.

 

summary_10