Sum up days of the week sales.

[mudflap]

Ok.

I am trying to sum each days sales .
So what I want to do is look at the date if it = 's mondays date add it to the next field if it ='s mondays date.
and so for for each day of the week.
I am willing to change it for each week if necessary.

 

[mbarron]

I would create a formula for each day of the week you want to capture data.

For Monday use:
@monday
if dayofweek({date.field})= 2 then {sales.field}

then do a summary for each field.

Mike