To add sub-totals, right-click on a dimensional fields, navigate to Sub Totals and choose the sub-total type.  Sub-totals are calculated within the groupings of preceding fields.

Sum: The total of the group

Avg: The average of the group

Min: The minimum value in the group

Max: The maximal value in the group

Count: The number of Members in the group

 

Examples

Consider the following data:

[Date]	[Store]	[Sales]
April	Store A	10
April	Store B	20
May	Store A	30
May	Store B	40

 

Adding sub-totals to the [Store] field will yield the following results:

[Date]	[Store]	[Sales]
April	Store A	10
April	Store B	20
April	SUM	30 {10+20}
April	AVG	15 {(10+20)/2}
April	MIN	10 {April/Store A}
April	MAX	20 {May/Store B}
May	Store A	30
May	Store B	40
May	SUM	70 {30+40}
May	AVG	35 {(30+40)/2}
May	MIN	30 {May/Store A}
May	MAX	40 {May/Store B}

 

Adding sub-totals to the [Date] field, will yield the grand total results:

[Date]	[Store]	[Sales]
April	Store A	10
April	Store B	20
May	Store A	30
May	Store B	40
SUM		100 {10+20+30+40}
AVG		25 {(10+20+30+40)/2}
MIN		10 {April/Store A}
MAX		40 {May/Store B}