Displaying Totals Using Standard Calculations

After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Apply footer calculations


You can use standard calculation functions to make quick calculations on data.

If standard calculations are not sufficient for your needs, you can use the formula language to build custom calculations.

The following standard calculations are available:

SumCalculates the sum of the selected data.
CountCounts all rows for a measure object or counts distinct rows for a dimension or detail object.
AverageCalculates the average for the data.
MinDisplays the minimum value of the selected data.
MaxDisplays the maximum value of the selected data.

Displays the selected data as a percentage of the total. The results of the percentage are displayed in an additional column or row of the table.

Percentages are calculated for the selected measure, compared to the total results for that measure on the table or break. To calculate the percentage of one measure compared to another measure, you need to build a custom calculation.

When you apply standard calculations to table columns, the calculation results appear in footers. One footer is added for each calculation.

Log in to track your progress & complete quizzes