Returns the parent values of the member being calculated in the specified
dimension.
Syntax
@PARENTVAL (dimName [, mbrName])
Parameter | Description |
---|---|
dimName | Single dimension name specification that defines the focus dimension of parent values. |
mbrName | Optional. Any valid single member name or member combination, or a function that returns a single member or member combination. |
Example
This example is based on the Sample Basic database. The formula calculates
Market Share for each state by taking each state’s Sales value as a percentage
of Sales for East (its parent) as a whole. Market Share->East is calculated
as East’s percentage of its parent, Market.
"Market Share" = Sales % @PARENTVAL(Market,Sales);
This example produces the following report:
Cola Actual Jan Sales Market Share ===== ============ New York 678 37.42 Massachusetts 494 27.26 Florida 210 11.59 Connecticut 310 17.11 New Hampshire 120 6.62 East 1812 37.29 Market 4860 100
Adding the “Market Share” member and formula to the outline would produce
the same result as above.
See Also
- @MDPARENTVAL
- @SPARENTVAL
- @ANCESTVAL