currentdate and monthtodate help!

Hi,

I'm trying to make a report that calculates the sales for some products,
it should show the sales of the current date inaddition to the sales of month to date on one line. This seems easy but the problem is when I'm trying to put a formula for the current time the system is taking the first records' date only, and ignoring other invoices dates.
Well gurus, where could be the problem, I tried to change the linking with no use...!

thanks in advance,,,,,,,Can you explain this little bit more with some real data example

and from your question only thing I found is you need Sales group by Month Am I correct ??

If yes... use group by function for Monthly Sales