Difference between revisions of "Repeaters"
(→Adding a repeater) |
(→Adding a repeater) |
||
| Line 19: | Line 19: | ||
* The render range | * The render range | ||
** This is the area that is displayed in the final repeater | ** This is the area that is displayed in the final repeater | ||
| − | ** $B$ | + | ** $B$16:$D$21 in the example above |
* Input range | * Input range | ||
** This is where the member parameters will be inserted | ** This is where the member parameters will be inserted | ||
| − | ** $ | + | ** $C$2 in the example above |
==Advanced usage options== | ==Advanced usage options== | ||
Multiple hierarchies with non-empty | Multiple hierarchies with non-empty | ||
Revision as of 12:10, 30 August 2017
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
Multiple hierarchies with non-empty
