The Calculation Type panel accepts input for the following items for a percent difference from prior period calculation:
Measure -- Select a measure or a dimension member for which you want to calculate the percent difference from the prior period.
Over -- If there is more than one time dimension, then a box appears to allow the selection of the proper time dimension. Otherwise the default time dimension is used.
In -- Select the hierarchy for the specified dimension.
From -- Choose one of the following items to indicate time periods:
Year ago -- Requests a value from the previous year.
Period ago -- Requests a value from the previous period.
Number of periods or years ago box -- Requests a value from a specified number (entered in the number box) of periods ago; also can indicate levels of time such as Year, Quarter, or Month.
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.
The formula for this calculation is:
((Current Value - Previous Value) / Previous Value)
This formula is used to calculate the difference in percent between a value from the current time period and a value from a previous time period.
An example of this calculation is:
Percent Difference = ((Sales June 2001 - Sales June 2000))/Sales June 2000)