how to do cumulative sum of data?

[#1]

I have an requirement to do cumulative sum of data for last 10 years with respect to quarter and output should only shows two years of data.

For reference I am showing for three years.

Year  Quarter    Sale                                  Output should have only two years data eventhough historical years are there.

                                                                          2013    Q1                100

2012    Q1         10                                            2013    Q2               110

2012    Q2         20                                             2013    Q3              130

2012    Q3         30                                             2013    Q4              160

2012    Q4          40                                          

2013    Q1         10                                             2014   Q1                200

2013    Q2         20                                             2014   Q2                210

2013    Q3         30                                             2014   Q3               230

2013    Q4          40                                             2014  Q4               260

2014    Q1         10

2014    Q2         20

2014    Q3         30

2014   Q4           40

Please let me know how to solve this issue?

[PrashantSangle]

Hi,

In your expression to calculate Sales nullify Year field

try like

sum({<Year=>}Sale)

Regards

[#3]

Hi,

Can you explain how to do this and can you implement in attached qlikview file

[#4]

Here it is

[#5]

Hi ,

Thanks For the prompt reply

But I have to get only for last 2 years eventhough 3 years data is there .

and also want the output as below.

Years	Quarter	Sale	Accumulated
2014	Q1	10	100
2014	Q2	20	110
2014	Q3	30	130
2014	Q4	40	160
2015	Q1	10	200
2015	Q2	20	210
2015	Q3	30	230
2015	Q4	40	260