> For the complete documentation index, see [llms.txt](https://docs.pentaho.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.pentaho.com/pba/9.3-analytics/pentaho-analyzer-cp/set-analyzer-report-options/turn-on-drill-through-links.md).

# Turn on drill-through links

You can use drill-through links in Analyzer to view all individual records that make up an aggregate value in your report. Turning on drill-through links turns all non-calculated number fields into links which, when clicked, bring up a configurable data grid that enables you to quickly view more details for that data point, without having to reconfigure your report. The drill-through grid shows all levels and non-calculated measures that are defined in the report cube by default.

If needed, you can select the columns you want to show in the grid so that report designers only see the selected columns. This is useful if your report cube contains many levels and measures and you want to show only specific data for analysis.

Drill-through links are not available under the following conditions:

* Any calculated measures, including schema-defined calculated measures and user-defined measures, such as percentages, running sum, and trend measures.
* Measures and levels set as hidden in the **Available Fields** list will not be visible in the **Drill-Through** view. For more information, see [Hide or Unhide Fields](/pba/9.3-analytics/pentaho-analyzer-cp/working-with-analyzer-fields/hide-and-unhide-fields.md).
* Subtotaled cells.

Follow the directions below to turn on drill-through linking in the Report Options dialog box.

1. In the **Cell drill-through** section, select the **Drill-through links on measures** check box.

   The number fields in your report will turn into links.

   ![Setting cell drill-through](/files/EXKIb4hV7U5R3630h6EY)
2. Click the **Select drill-through columns** to select the columns you want to appear.
3. Click **OK**.

   The measure fields in your report will turn into links.

You now have drill-through links for numeric, non-calculated members.

If you choose, you can later disable the drill-through links by clearing the **Drill-through links** check box.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.pentaho.com/pba/9.3-analytics/pentaho-analyzer-cp/set-analyzer-report-options/turn-on-drill-through-links.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.