I am currently using the following expression...

[James_Fussell]

I am currently using the following expression to give me a daily sales total by rep.

=SUM(SELECT(Customer Orders[Order Total],AND([Date2]=TODAY(),[Rep]=[_THISROW].[Initials])))

I am struggling to get a month-to-date, and year-to-date sales total. Can you help with this?