Cumulative value for each Quarter selection

[keerthanagowsi]

Hi All,

I have a requirement to do a cumulation based on quarters. So that if i select Q1 it should display Q1 value, if i select Q2,it should display (Q1+Q2) value and so on. Currently am using the below expression

Aggr(RangeSum(above( Sum(Quantity),0,RowNo())),week,(quarter,NUMERIC))

This expression works in a way that if I select both Q1 and Q2, it gives me Q1 value for Q1 and (Q1+Q2) value for Q2, but if i select Q2 alone, it gives me only the Q2 value and not getting cumulated. But the real case is even though i select only Q2 or Q3, it should show the cumulated value.

Tried this : Aggr(RangeSum(above( Sum({<quarter=>}Quantity),0,RowNo())),week,(quarter,NUMERIC))

But not worked.

Example:

Week Quarter Quantity

1 Q1 10

1 Q2 20

1 Q3 30

1 Q4 10

Output: If i select any quarter, it should show the cumulation.

Q1 -> 10, Q2 -> 30(20+10), Q3 ->  60(30+20+10), Q4 -> 70(10+20+30+10)

Any help is appreciated, as i stuck here for last 2 days.

Thanks in Advance.

Regards,

Keerthana

[JordyWegman]

Hi Keerthana,

Instead of using a formula, check the As-Of-Table!

Jordy

Climber