Drill Anywhere into Charts/Pivots

The Drill Anywhere feature allows you to drill into and add items in the Chart and Pivot sections that are resident in the Results section, but have not been included in the Chart and Pivot you are viewing. Drill anywhere items are broken out as a new label item(s) automatically. The advantage of this feature is that it instantly allows you to add items to the data set to reflect temporary and hypothetical situations.

The extent to which you can drill into your data depends on how the original query was built, since Drill Anywhere retrieves data from the Results section.

To drill anywhere into a Chart:

Select a pivot dimension or chart item for analysis.
Select Drill Anywhere on the shortcut menu.
A shortcut of drill anywhere items displays.
Select an item on which to drill down.
The report is redisplayed, breaking out the additional data as a new label item.
Note:
If no options are available in the Drill Anywhere drop down list, all available items have been referenced in the chart.