Repeaters

Repeaters are a visualisation introduced in Version 9.1.

They allow you to select a range in Excel, parameterise the range, and then repeat the range for each input parameter.

For example, below is a report for sales by country. The report template is created once, and then repeated for each country.

The yellow cell shows where the country input goes, and then the formatted part of the report is repeated for each country on the right.

Adding a repeater

When adding a repeater, the first thing you do is pick the members that will be used as input to the report.

Next you need to pick three ranges:

• The repeat range
  • This is the entire area that needs to be repeated, including and work are where results are calculated
  • $B$2:$D$21 in the example above
• The render range
  • This is the area that is displayed in the final repeater
  • $B$16:$D$21 in the example above
• Input range
  • This is where the member parameters will be inserted
  • $C$2 in the example above

Advanced usage options

Display if True Multiple hierarchies with non-empty