RP002
Report RP002 is an example of how the Data Area can be used to filter one set of data with another. Specifically, it shows how to display budget figures for one year only where the actual figures for the previous year were above a specified amount.
The report has two hyperblocks. The first has two value cells. In the first value cell, a formula returns the actual results for products in 2016. In the second value cell, a formula returns the budgeted figures for 2017.
This table shows the hierarchies and elements to which the formulas refer:
| Hyperblock 1 | |
|---|---|
| Value cell 1 - actuals | Value cell 2 - budget |
| CHANNEL: All Channels | CHANNEL: All Channels |
| MEASURE: Units | MEASURE: Units |
| POS: All POS | POS: All POS |
| PERIOD: 2016 | PERIOD: 2017 |
| REGION: All Regions | REGION: All Regions |
| VALTYPE: Actual | VALTYPE: Budget |
The second hyperblock also displays the budgeted figures for products in 2017 - but it has a filter to display only those elements where the actual results in 2016 were above 6 million.
The filter is Value greater than 6000000 and the Data Area
refers to these hierarchies and elements:
- CHANNEL: Current Element. That is, All Channels.
- MEASURE: Units
- POS: Current Element. That is, All POS.
- PERIOD: 2016
- REGION: Current Element. That is, All Regions.
- VALTYPE: Actual
To display the filter and Data Area:
- Display Report RP002
- In Design mode, click the border of the second hyperblock.
- In the List Designer, open the Filter pane.