Help in Monthly MIS Query report for 'Cumulative This Year' Figures

[Former Member]

mpr.png
Hello,

I already have a query report made as Monthly Progress Report. However, there's a bit modification required.

Let's say, We are in 15th date of June 2018. Our production for April was 100 nos. and May was 150 nos. From 1st to 15th June, we have 70 nos. production.

Result Showing:

Figures in Month column are perfect however, 'Cumulative This Year' figures show the figures from 1st April 2018 till date. I.e. (100+150+70) 320 nos.

Result Needed:

Cumulative This Year Should consider the Monthwise figures. It has to be considering figures till last date of previous month. I.e. (100+150) 250 nos.

Please help!

Thanks and regards,

Jitender Bhati

[kothandaraman_nagarajan]

Hi,

Please share your query here to check.

Regards,

Nagarajan