Propagate across sheets allows the creation of one or more worksheets based on the current worksheet, with members of one hierarchy swapped for other selections.

To activate the function, right-click on the selected member for the hierarchy you want to propagate (on either a Grid or an XL3Member formula), select Anaplan XL > Propogate Across Sheets...,and choose the elements for which you want to create additional sheets. On the new sheets, the formatting and print layout are identical. The only change is the selected member on the propagated hierarchy.

There are a few options that affect the results:

  • Insert as Text: The result will vary depending on what was clicked to perform the propagation:
    • If a formula was right-clicked, the resulting worksheet(s) will have all their formulas converted to values.
    • If a grid was right-clicked, the corresponding Grid on the target worksheet(s) will be converted to values.
  • Keep all grids active on new sheet: With a multi-grid source sheet, even if only one grid is propagated, all grids will be copied and be active on new sheet.
  • Move Grid references to new sheet: Any copied Grids will have any Excel range references moved to their new worksheet.

Advanced propagate

Advanced propagation allows the results to be based on a particular data query. For example, give me a new sheet for each product with sales greater than x or any of the other ranking, sorting, and filtering options.

Create new workbook

The option to propagate to a new workbook will create a new workbook and populate it with all the new worksheets.