Operation “Show By” of the Context Menu

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

Let us do the “Show 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 Show 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 “Show By”.

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

In a similar way “Show by” is working for table cells. If you perform “Show 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”: