Use Table Linking

You can link a table or graph to another table or graph or a page layout by selecting Manage Links from the Actions menu on the toolbar.

The links enable you to pass the context of a table or graph to another table or graph or a page layout.

In the Manage Links dialog box, you can use these tabs:

To Table, Graph, or Page Layout: Create a link to another table or graph or to a page layout.
From Table or Graph: Link to the open table or graph from another table or graph.

Use the Add Row icon to add a link.

Enable dynamic linking: Select this check box to enable dynamic linking. If selected, then the target table or graph is refreshed when the selections in the source table or graph change.
Pass highlighted selections and selected members: If you select this option, then whatever you highlight in the current table or graph is passed as the context along with the filters in the Selector Tool to the target table, graph, or page layout.
Pass user-specified parameters: If you select this option, then you can select the level and context of the source table or graph to pass as link parameters to the target table, graph, or page layout.
Include measure filters: Select this check box to apply measure filters that you defined on the Measure Filters tab in the Selector Tool to a linked table or graph. This check box is enabled:
- After you select the Pass user-specified parameters option.
- If the From Table contains measure filters.

Note: If you're linking a summary table that lists configure-to-order (CTO) items to a detail table that lists the CTO items along with their option classes and options, select the Pass highlighted selections and selected members option.

After you define the link, use the Drill icon on the toolbar to drill to the linked table, graph, or page layout.

Dynamic linking is supported only from a pivot table displaying measures to another pivot table or graph displaying measures. It's not supported from the entity tables such as items, item structures, and so on.