Using calculations

Using calculations is another useful feature that we can apply to the data.

Almost every report uses some kind of calculation: a total summation, a percentage, calculating the average sales across various products, or performing simple minimum or maximum functions—we can use it with measure, age, and date data.

Calculations are aimed to get the bottom line, that is, the understanding of how good or bad the results are, as they complete the picture of the data and a measurable analysis of the results provide the final insight.

How to do it...

We want to get familiar and use the calculations offered by the Analysis toolbar. By marking a measure column, the Analysis tab will become available, as shown in the following screenshot:

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.