## Summary Calculations

Summary calculations are aggregate functions used for sub-totals and totals. Summary calculations can be set in the Ad Hoc View Panel.

• In the table views, each field can display a single summary calculation. It is automatically applied to all groups in the table. Summaries appear at the bottom of each group as well as the bottom of the view. When a new group is being added it will include a summary for each column.
• In the crosstabs, each measure will display a summarized value. They will determine the values of the Totals at the intersection of each row and column.
• In charts, the type of the chart shall determine whether the measures are summarized.

Default Summary Functions in Calculated Fields

 Datatype Default Summary Calculation Description Numeric Sum Display the sum of all values in the set. Date CountAll Displays the total number of values in the set. String CountAll Displays the number of values in the set. Boolean CountAll Displays the number of values in the set. Aggregate AggregateFormula Uses the aggregate formula as the summary. Combined None The summary calculation is null.

Setting a measure’s summary function in any type of view

 Function Meaning Available for… AggregateFormula Uses the same aggregate formula as the summary Aggregate Average Displays the average of all values in the set. Numeric CountAll Displays the number of rows in the set. Boolean, Date, Numeric, String CountDistinct Displays the number of unique values in the set. Boolean, Date, Numeric, String Custom Allows you to enter an aggregate calculation for the summary. Aggregate, Date, Numeric Max Displays the highest value in the set Date, Numeric Median Displays the median value in the set Date, Numeric Min Displays the minimum value in the set Date, Numeric Mode Displays the value that occurs most frequently in the set. Boolean, Date, Numeric, String None The aggregate function is null Aggregate, Boolean, Date, Numeric, String Range Displays the difference between the minimum and maximum values of the set Numeric RangeDays Displays the difference in days between the minimum and maximum values of the set Date RangeHours Displays the difference in hours between the minimum and the maximum values of the set DateTime RangeMinutes Displays the difference in minutes between the minimum and the maximum values of the set DateTime RangeMonths Displays the difference in months between the minimum and the maximum values of the set Date RangeQuarters Displays the difference in quarters between the minimum and maximum values of the set Date RangeSemis Displays the difference in semi-annual periods between the minimum and maximum values of the set Date RangeWeeks Displays the difference in weeks between the minimum and maximum values of the set Date RangeYears Displays the difference in years between the minimum and maximum values of the set Date Aggregated Formula Uses the aggregate formula used to define the calculated field as the summary function Aggregate StdDevP Displays the standard deviation for the population of the set Numeric StdDevS Displays the standard deviation on a sample for the set Numeric Sum Displays the grand total for the set Numeric WeightedAverage Displays the weighted average for the set based on a second numeric field or expression. Numeric

Hints

• If you select a summary calculation other than the default one, that calculation is shown in parentheses after the field name in the fields picker.
• Create a custom Summary calculation for a field or measure.
• Remove summaries by setting the summary function to None.
• Only AggregateFormula, Custom or None are supported as summary calculations for aggregate functions.
Go to Top