Using the drill formula

If we want to keep track of the drill-filtered values and display the data in a more preventative way, or in cases where we want to print the results, we need to add a title that will display the drill values.

Getting ready

We will insert the drill filter values into the report title using the DrillFilters formula located in the document functions folder.

How to do it...

Let's perform the following steps:

1. We need to mark the title cell, switch to the formula editor, and choose the DrillFilters formula, as shown in the following screenshot:

   

2. The content of the title will change according to the values picked in the drill filters, so it's very easy to keep track of the changing values, and if we are going to print the report, we need to be very clear about what the context of the displayed data is.

Tip

When document hierarchies are defined properly in the universe, when we use them for a drill in our reports, the dimensions that turn into filter drop-down lists will behave in...