I have a internal table with fields and data as:
salesoffice, coordinator, invoicetype , invoice_dt, order_creation dt
london AA 001 26/01/2007 25/01/2007
london AA 001 23/01/2007 22/01/2007
london BB 003 11/01/2007 01/01/2007
I want the summarized report in this format
sales_office, coordinator, inv_type, wk1, wk2
london AA 001 2 0
BB 003 0 1
where wk1 is the diff between invoice_dt and order creation date. if the diff is <=7 it counts the number of records and put in wk1, simmilarly for wk2 i.e if diff is <=14.
if any body can help me with this that will be great.