Comulative Opening in Pivot Chart

[vijayit43]

Hi Expert,

              In QlikView Pivot chart we want to cumulative Opening date wise in a row from a given period,  for detail example given bellow

Code               Date               Amount

cust/001     01/02/2015               5

cust/001     02/02/2015               10

cust/001     03/02/2015               15  

cust/001     04/02/2015               20

cust/001     05/02/2015               25

cust/001     06/02/2015               30

cust/001     07/02/2015               35

cust/001     08/02/2015               40

cust/001     09/02/2015               45

cust/001     10/02/2015               50

when we give filter date from 04-02-2015 to 09-02-2015 the show result at this type

Code           Date               Opening

cust/001     04/02/2015          30

cust/001     05/02/2015          50

cust/001     06/02/2015          75

cust/001     07/02/2015          105

cust/001     08/02/2015          140

cust/001     09/02/2015          185

how to achieve this please suggest

Attached Sample QV Please Suggest..

[Gysbert_Wassenaar]

Try sum(aggr(rangesum(above(total sum({<Date=>}Amount),1,rowno())),Date))

See attached qvw.

[vijayit43]

Hi Sir,

        Please Suggest Sample QV Attached for refrence.

[vijayit43]

Hi Sir,

          Please Suggest..