Help with Set Analysis expression

[bismart]

Hi

Can anyone help with Set analysis statement which would solve my issue please

Thanks...

YearMonth OrderDate Item Qty
201001 01/01/2010 A 2 A
201001 20/01/2010 A 2 B
201002 05/02/2010 A 2 C
201003 10/03/2010 A 2 D
201003 20/03/2010 A 2 E
201004 02/04/2010 A 2 F
201004 15/04/2010 A 2 G
201004 16/04/2010 A 2 H

I want to calculate a column using Set Analysis (OrderDate >= Monthstart(YearMonth) + 42 days)

201001 A 6 A+B+C Upto 6 weeks (42 days) from start of month for field YearMonth (i.e. 201001 = 01/01/2010 etc.)
201002 A 4 C+D
201003 A 6 D+E+F
201004 A 6 F+G+H

[bismart]

Sorry... that should read

I want to calculate a column using Set Analysis (OrderDate <= Monthstart(YearMonth) + 42 days)

thanks