@mystefied_ , Please try this: select
month,
month_total,
month_total / lag(month_total, 1) over (order by month) as percentage_over_previous_month,
sum(month_total) over (order by month) as running_sum,
sum(month_total) over (order by month) / sum(month_total) over (partition by 1) as running_percentage
from (
select
trunc(stock_date, 'MONTH') as month,
sum(stock_price) as month_total
from table4
group by trunc(stock_date, 'MONTH')
) x Cheers, André -- Was your question answered? Please take some time to click on "Accept as Solution" below this post. If you find a reply useful, say thanks by clicking on the thumbs up button.
... View more
