Calculation Wizard: Prior value calculation

The Calculation Type page accepts input for the following items for a prior value calculation:

Measure

Select a measure or a dimension member for which you want to return the prior value.

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.

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. 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.

Formula Description

This formula is used to return the value of a measure from an earlier time period.

Example

An example of this calculation is:

Sales a Year Ago = Sales from September 2000 if current time is September 2001