Share Calculation

The Calculation Type panel accepts input for the following items for a share calculation:

Share of -- A measure or calculated measure that is dimensioned by the Product dimension; can also be a dimension member.

For -- The dimension for which the share is to be calculated.

In -- The hierarchy to be used while calculating the share for the selected dimension.

As a percent of -- The dimension member to be used as a baseline to calculate the share. Select one of the following choices:

Number Format -- Select one of the default number formats to use for this calculation or choose Options to specify another format.

Options -- Displays the Number Format dialog, in which you can specify a format for the calculation.

This type of calculation applies to measures only.

Formula Description

Formula

The formula for this calculation is:

(Current Member/Specified Member)

Description

This formula is used to calculate the percentage contribution of one item relative to a total value.

Example

An example of this calculation is:

The share of 19" TV sales to Total TV Sales = (19" TV Sales/Total TV Sales)