ytd amount, last year YTD amount, monthly amount
439861Mar 9 2005 — edited Jul 29 2006Dear all,
I have a table
create table mthly_sale
(sale_date date,
sale_amount number) ;
now, v need to create a report that have monthly amount for this year, ytd amount for this year, last year YTD amount
example, if user select 200403, the report will as below
Jan | Feb | Mar | ytd | ytd prev
1 | 2 | 3 | 6 | 4 (last year ytd from jan to mar)
anybody know how to do???