Calculation Wizard: Period to date calculation

The Calculation Type page accepts input for the following items for period to date calculation:

Measure

Select the measure for which you want to calculate values.

Over Time In

Select a hierarchy in the time dimension.

At Level

Select a level in the time hierarchy for the period calculation.

Formula Description

This formula is used to sum measure data over time periods, to create cumulative measure data.

An example of this calculation is:

Year-to-date sales to March = Jan Sales + Feb Sales + March Sales