Function **PreviousPeriods** works in an optimized way to calculate cumualtive values. For month report, it will sum any previous month within a same quarter, them sums any previous quarter within a year and then sums any previous year.

If you have the formula, you are using fixed value 1 as formula for cumulative values it will give you 1 for a quarter or year as well.

Here is how you can calculate this counter.

if you are using eazyBI version 5. or older (or on cloud) with Time dimension on Rows we have a default option **Add calculated** you can apply to any measure and it will calculate a cumulative sum of any measure without additional calculations.

For your report, you are using Time columns. You would like to address members of the same Time hierarchy level you have in a report and sum up from the first member until each column (current member):

```
SUM (
{[Time].CurrentHierarchy.Level.Members.Item(0):
[Time].CurrentHierarchyMember},
[Measures].[T_E_S_T]
)
```

Daina / support@eazybi.com