You can repeat the same expansion on multiple row and column key ranges.
Note
Multiple expansions - A more generic case of “repeated expansions” is when the MemberSet changes for each one of the ranges defined in the corresponding row (or column) key range. To assign a different member set to each expansion, the user can specify multiple member sets in the MemberSet field, delimiting them with a pipe character (“|”).
You can perform multiple expansions in which the MemberSet changes for each of the ranges defined in the corresponding row (or column) key range.
To assign a different member set to each expansion, you can specify multiple member sets in the MemberSet field, delimiting them with a pipe character (|).
In the following example, the same row expansion has been performed in two sets of rows, each one with its own column keys:
RANGE |
VALUE |
---|---|
PageKeyRange |
Sheet1!$F$2:$F$9 |
ColKeyRange |
Sheet1!$G$13:$I$13,Sheet1!$G$20:$I$20 |
RowKeyRange |
Sheet1!$E$15:$E$17,Sheet1!$E$22:$E$24 |
CellKeyRange |
|
GetOnlyRange |
Sheet1!$G$15:$I$17,Sheet1!$G$222:$I$24 |
FormatRange |
Sheet1!$E$13 |
PARAMETER |
EXPANSION 1 |
---|---|
ExpandIn |
ROW |
Dimension |
ACCOUNT |
MemberSet |
|
G |
H |
I |
|||
2008.JAN |
2008.FEB |
2008.MAR |
|||
15 |
Cash |
412,297,236.68 |
418,481,695.23 |
460,329,864.75 |
|
16 |
Accrec |
41,229,723.67 |
41,848,169.52 |
46,032,986.48 |
|
17 |
Inventory |
||||
2008.APR |
2008.MAY |
2008.JUN |
|||
22 |
Cash in Bank |
448,821,618.13 |
455,533,942.41 |
462,387,251.54 |
|
23 |
Accounts Receivable |
112,205,404.53 |
113,888,485.60 |
115,596,812.89 |
|
24 |
Inventory |
44,882,161.81 |
45,555,394.24 |
46,238,725.15 |