Summaries

Top  Previous  Next

By default, all summaries are displayed as a sum of the data field.

 

pivot_summaries_01

 

 

You can change the summary type by clicking on the summary type item on the Columns panel on the right.

 

pivot_summaries_02

 

 

You can also add columns to display a different summary type.  Let's say we want to add a column to display average sales.  Click on the Add column button on the Columns panel.

 

pivot_summaries_03

 

 

Select the data you want to display for this new column.  In this example, we select the average summary type, and create a new label for this new column.

 

pivot_summaries_04

 

 

Once completed, the new column is created and displayed.

 

pivot_summaries_06

 

 

Summary variations

 

Summary variations change how the data is displayed.  Instead of just displaying the summarized value, each value is compared to another value.  You can select a summary variation by clicking on a column's summary variation item:

 

pivot_summaries_07

 

 

In the example below, the sales amount is now displayed as a percentage of the row, to allow us to view the trend of sales for each day of the week for each quarter and year combinations.

 

pivot_summaries_08