In the object title, you can insert the measure option. This will change the object title dynamically if you use the measure selector in the analysis.

The title can be translated and the font formatted if needed.

Now, add the measure selector to the criteria bar and see what happens when we change the measure.

We can refine the title so that it shows the measure name, the grand total for the measure and perhaps an average.

Click the small drop-down arrow to open the advanced text editor.

Place the cursor to the right of {Measures} click the drop-down arrow again and select <New numeric value>

Now we have added a new value to the title. This value can be used in different ways but we just enter a simple calculation **column.sum** that calculates the total units sold.

There are a number of different calculations. The most useful will typically be average (avg), total (sum), minimum (min) and maximum (max) calculations.

E.g., this is how to add an Average function:

## Comments

Please sign in to leave a comment.