basic question about analytic functions

I got a basic query that I need to turn into a analytic function query.

Can someone help me translate it? I tried several ideas (using over() etc. but I'm no guru at this and have failed). I'm sure it's simple.

Here is a normal query that I need to translate as an analytic function query:

select dev1.sales_div_no, dev1.sales_div_name, sum(fact.t_total_sales_units) "T UNITS", sum(fact.l_total_sales_units) "L UNITS"
from dim_dev1_plan dev1, fact_weekly_plan fact where dev1.dev1_id=fact.dev1_id
and fact.per_id between 440 and 540
and dev1.sales_div_no between 300 and 500 group by dev1.sales_div_no, dev1.sales_div_name order by dev1.sales_div_no, dev1.sales_div_name;

Thanks in advance for any assistance.

Udo. Received on Tue Feb 18 2003 - 12:59:19 CST