Using aggregate functions
Aggregate functions are used whenever we want to perform calculations on measure objects. This isn't always the case as we can also perform a count calculation on a dimension or an attribute object.
We distinguish between two main uses of aggregative functions as follows:
- A summarized aggregative function returns the result in the footer or in a single cell, such as Sum or a Max calculation
- A row-level calculation shows the aggregative result, such as the percentage
The main aggregative functions are as follows:
- Sum
- Average
- Min/Max
- Percentage
- Count
How to do it...
The
count function counts each unique value once, so if we have 10K rows that contain only seven different values, the result of count will be 7.
If we need to count the ...
Get SAP BusinessObjects Reporting Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
