selected date values plus previous months monthend sales

[anat]

Hi All,

i have Date and sales fields

having 5 years data ,my requiremtn is:

in Date field if i select 9th Mar 2022 then i need to show the sales like

sum(sales) of 9th Mar 2022 + 31st Jan 2022 sales + 28th Feb 2022 sales

means selected date sales + previous months monthend sales

[anat]

any thoughts on this query?