Skip to Content
0
Former Member
Feb 27, 2007 at 07:12 PM

Cumulated Key Figures in BEx query (by Quarter, Not Year)

37 Views

I am returning Key Figures by Year and Quarter in a query. I want the Quarter values to accumulate, but only Within The Year. Instead, when I select the Cumulated box, the Key Figures accumulate not only within the Year, but across the Years as well. Example

2005 Q1 Q2 Q3 Q4 2006 Q1 Q2 Q3 Q4

5 12 24 42 47 54 62 68

The 2005 numbers are fine, but notice how the values keep going up, even from Q4 of 2005 to Q1 of 2006. I want the accumulation to "start over" at the beginning of each year, not accumulate across the year