@PARENTVAL

The @PARENTVAL() function returns the parent values of the member being calculated in the specified dimension.

@PARENTVAL (dimName [, mbrName])

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

See Also

@MDPARENTVAL
@SPARENTVAL
@ANCESTVAL

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.