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
