Custom N period running total

Use custom N-period running total to define a relative time member that is an aggregation of a defined number of consecutive periods.

You must specify the number of periods, target period with offset, and context period with offset. The endpoint is defined by the target and context properties.

For example, to define a relative time member for "Trailing 6 months, next year" you specify:

  • number of periods: 6
  • target period: months
  • target period offset: -1
  • context period: year
  • context offset: 1

This example is illustrated in the following diagram.

Figure 1. Illustration of custom N period running total example
illustration of trailing six months, next year example

You cannot select the highest level. For example, if levels are All, Year, Quarter, and Month, you cannot select Year as the target period.