A key range is the cell range that displays the dimension IDs from the current view.
The Key Range parameter uses the values in the Range/Value table.
You can use the same EvDRE function to support multiple key ranges on both the columns and rows simultaneously.
You can use multiple dimensions in both Column key and Row key ranges.
You can define a multiple key range by entering a range for the first heading set, a comma (,), then a range for the second heading set.
Note
You can activate this feature by assigning multiple ranges to the same EvRNG function. See EvRNG.
You can assign a maximum of 30 parameters to any Excel function.
To use multiple dimensions in a key range, you must enlarge the ranges to accommodate the desired number of dimensions. The ColKeyRange has more than one row and the RowKeyRange has more than one column.
To include a blank line between retrieved values, you can leave a row or column blank without entering multiple ranges.
If the formula is =EVDRE($B$3,A14:B20,A23:C29), the Key range parameter points to the data in cells A14:B20
. The first column (with the heading RANGE below) contains the
name of the range. You enter the range values in the second column (with the heading VALUE). The reserved range names allow you to order the ranges in any sequence, and skip any ranges that are unused or not required.
A |
B |
|
13 |
RANGE |
VALUE |
14 |
PageKeyRange |
Sheet1!$B$4:$B$11 |
15 |
ColKeyRange |
Sheet1!$G$3:$I$3 |
16 |
RowKeyRange |
Sheet1!$E$5:$E$25 |
17 |
CellKeyRange |
|
18 |
GetOnlyRange |
|
19 |
FormatRange |
Sheet1!$E$3 |
20 |
Options |
AutoFitCol |