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:
Total -- Specifies that the baseline consists of the total of all items on the level that is associated with the current member (that is, the item for which share is being calculated. This option is disabled for a dimension that has no hierarchies.
Parent -- Specifies that the baseline consists of the total on the level of the parent for the current member (that is, the item for which share is being calculated). This option is disabled for a dimension that has no hierarchies.
Level -- Specifies that the baseline consists of the total of a level to be specified. Choosing this item requires the selection of a value in the associated drop-down list. This list displays the names of levels from the selected hierarchy for the selected dimension that are available for calculating the share. This option is disabled for a dimension that has no hierarchies.
Member -- Specifies that the baseline consists of the total for a dimension member to be specified. Choosing this item requires the selection of a value in the associated drop-down list. This list displays the names of the dimension members that are available for calculating the share.
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.
The formula for this calculation is:
(Current Member/Specified Member)
This formula is used to calculate the percentage contribution of one item relative to a total value.
An example of this calculation is:
The share of 19" TV sales to Total TV Sales = (19" TV Sales/Total TV Sales)