Week Chart need to show data for last Week Day

[mhmmd_srf]

Hi All,

I have column chart, which is show sum(qty) by Week.

The chart will display Week, though it will show the qty of last day of week.

In the attached example.

In the desired chart, Week 27 should show value for 20190405 and for Week 28 chart should show for 20190508.

Could you please help me on this.

Thanks,

MS