Ytd in qlikview

[tripatirao]

Please check the attached excel I got the 1st report (please check the qlikview)

Please Help me to find out the YTD.

For example for MAY   for product  PEN it should be

100+(-50)+(-20)+70+(-90)=10

Here -50 mean Feb month sales of pen-Jan month sales of pen

For example for Apr   for product  PEN it should be

100+(-50)+(-20)+70=100

I have shared  the sample data along with my requirement YTD.

Please check and do the needful.

Regards

Tripati

[trdandamudi · Accepted solution]

May be as attached...