Day or Date range in Set analysis Expression

[Anonymous]

Dear Friends

I have an expression like below:

=sum( {<  NEW_AGENT_NAME={'*'},NEW_ENTITY_CODE={'CPM078361*'},BILL_TYPE={'SELL'}>}      sales)

I need to add a Day range to this in set analysis like from the 1st of a month to a particular date which is decided by value another column.

Example:   Value in other column is 16 then it should show sales from 1st of the month to 16th.   I have Day, DayMonth and Date field available as attached screenshot.   

How can I use these fields in set analysis.

Regards

Chintan

[MK_QSL]

=sum( {< Date = {">=$(=MonthStart(Max(Date)))<=$(=Max(Date))"},  NEW_AGENT_NAME={'*'},NEW_ENTITY_CODE={'CPM078361*'},BILL_TYPE={'SELL'}>}      sales)