The Calculation Type panel accepts input for the following items for a year to date calculation:
Measure-- Select the measure for which you want to calculate values.
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.
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 formula is used to calculate the sum of data from the beginning of the year to the current time period.
An example of this calculation is:
Year-to-date sales to March = Jan Sales + Feb Sales + March Sales