I am trying to create a search that reports on sales quantities that were billed / shipped between date ranges: previous 1 week, 1 months & same date ranges previous year etc.

Criteria:
(sales orders billed, or
invoices paid)
company department

Report:
item name
item description
sum of quantities billed/shipped by period set in formula

I need quite specific instructions on the basic search formula as this SQL exceeds my knowledge - I can adapt once I have a working formula.


From a previous thread the following I am trying to adapt ... and am failing:

case when {transaction.type} = 'Cash Sale' and {transaction.location} = {inventorylocation} and ({today} - {transaction.trandate}) BETWEEN 1 AND 7 then decode({transaction.type}, 'Cash Sale' , nvl(-{transaction.quantity},'0'),0) else 0 end