When using Grid reports it is possible to link multiple Grids together to be driven from the same hierarchy.

  1. Insert the two (or more) grids that you require
  2. Select the Grid Links ribbon item (or in Excel 2003 and below, the Anaplan XL ribbon > Grid Links... menu item):
  3. Select the grid that you want to be the primary in the dropdown:
  1. Find the grid that you want to be driven in the table, and select the cells to select the hierarchies you want to be linked. You can choose a two-way link (changing either grid will drive the other grid) or a one-way link (only changing one of the grids will change the link).
IconDescription
Two-Way link
One-Way link (the current selection is the primary)
One-Way link (the current selection is the secondary)

Linking means that whatever changes are made to the driving grid's linked hierarchy will be reflected in the driven grids. The actual result will depend upon the structure of the driven grid. For example, if you linked on the Product hierarchy in the driven grid and this appeared as a column in all the linked grids, then drilling down the Product column in the driving grid will drill down all the grids. This also applies to any member selection operations.

Grids can also be linked to Dimension Slicers and Small Multiple Charts.

This option is also available from the Anaplan XL ribbon > More > Grid Links.