> 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/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/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. 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 by asking a question. Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters: ``` GET https://docs.pentaho.com/pba/pentaho-analyzer-cp/set-analyzer-report-options/turn-on-drill-through-links.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case. 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.