Add multiple Dynamic Reports

You can add multiple Dynamic Reports to your worksheet.

Before you begin

Adding multiple Dynamic Reports is a great way to view, analyze, and compare data. Before you add multiple Dynamic Reports, it is important to be aware of the following limitations:
  • Use a top to bottom design approach. Additional Dynamic Reports should only be added below an existing Dynamic Report.
  • Multiple Dynamic Reports cannot exist side by side and the rows of two Dynamic Reports can never overlap.
  • Additional Dynamic Reports cannot be added to the left of the first Dynamic Report.
  • Multiple Dynamic Reports on the same worksheet will share the same format range. To learn more about formatting a Dynamic Report, see Report format.

Procedure

  1. Select a cell below an existing Dynamic Report.
  2. Right-click a view in the source tree, click Dynamic Report, and select At current location or At specified location.

Results

An additional Dynamic Report is added to the worksheet.

Note: If the values of your Dynamic Reports seem incorrect after adding multiple Dynamic Reports, ensure that no two Dynamic Reports have overlapping rows.