You can use standard functions to quickly calculate data.
The following standard calculations are available:
- Sum: Adds the selected data.
- Count: Counts all rows for a measure, or counts unique rows for a dimension or attribute.
- Average: Finds the average of the selected data.
- Min: Shows the lowest value in the selected data.
- Max: Shows the highest value in the selected data.
- Percentage: The percentage is based on the selected measure compared to the total for that measure in the table or break. The result appears in an extra column or row. To compare one measure to another, build a custom calculation.
When you apply standard calculations to table columns, the results appear in the footers. The system adds one footer for each calculation.
If standard calculations do not meet your needs, you can use the formula language to create custom calculations.
Let's Summarize What You've Learned
- Apply standard functions like sum, count, and average for quick calculations.
- Build custom calculations for more complex analysis requirements.