Using formulas
Formulas can be used whenever we need to add an additional calculation to the data or use an in-built function from the function libraries.
Let's take a look at how we can create different types of formulas, which will serve different purposes in our reports.
Getting ready
Our report data contains the Number of Customers and Number of Orders measures and the Country and Region dimensions; we want to add an average calculation that will display the average number of orders.
We first add a column to the right-hand side of the Number of Orders column using the right-click menu and by navigating to the Insert option and then choosing Insert column on right, as shown in the following screenshot:
After adding the new empty column, we mark it and click on the Formula Editor button located on the top left of the formula bar.
How to do it...
Perform the following steps:
By clicking on the Formula Editor button, we switch to the Formula Editor window where we will write the formula.
The formula...
