Operation “Drill by” of the Context Menu

In the context menu there is an operation “Drill by”. Let us look at the example. Assume you have a report of the following structure:

Let us do the “Drill by” operation in order to look the sum of sales for a specific product (for example, for “Road Bikes”) by all countries.

Select menu items Drill by → Geography → Country:

As a result we will have the following report:

As we can see, we have a report of sales by countries. The “Product” hierarchy has come to the context. If you show the member selector for the context, you will see that the only one item is selected there – the one for which you’ve made the operation “Drill by”.

Therefore, we are watching sales only for “Road bikes”.

In a similar way “Drill by” is working for table cells. If you perform “Drill by” on the cell where “Road Bikes” and “CY 2016” intersect, you will get a report which displays sales in all countries for Road Bikes in the calendar year 2016:

As you may see, the context has 2 items – “Road Bikes” and “CY 2016”: