I need to report on products sold per day and per month.

 

The report is filtered by monthtodate.

Then I have two Running Total Fields:

Field to summarize = Products_ProductsSold_TotalQuantity

Type of Summary = Sum

Evaluate -> On change of field = Statistics_EventDateTime

Reset = Never

 

Works great

But now I need a second Running Total in this very report, which is only for today. (Statistics_EventDateTime = today)

 

How do I solve this riddle?