In business, metrics are quite frequently reported as accumulating totals. For example, consider reseller sales in the month of October. Although sales in this month alone are interesting and important, the accumulation of sales over the months of the year up to and including October may be more interesting, especially if you are tracking sales against an annual target.
To calculate accumulating totals, you must determine the set of time members over which a value is to be aggregated. This is done using the PeriodsToDate function:
PeriodsToDate( [Level , [Member]] )
The PeriodsToDate function returns the set of members from the start of a given period up to and including a specified member. The Level argument identifies ...