Set Analyis with current month and previous month

[tripatirao]

Dear All,

Please help me find out the required output.

I have attached the output what i want and the source file.

And also want the YTD value of corrosponding product.

Please do the needful.

Regards

Tripati

[tripatirao]

Dear Sunny,

I got my requirement as attached image.

Please Help me to find out the YTD.

For example for MAY   for product  PEN it should be

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

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