SQL & PL/SQL

Hi All,

I have the below example where i can calculate Percentage of individual values of the total value.

  WITH t1 AS (SELECT 1 as rnum,
                  5 AS value FROM DUAL
           UNION
           SELECT 2 as rnum,
                  10 AS value FROM DUAL
           UNION
           SELECT 3 as rnum,
                  15 AS value FROM DUAL
          )
select sum(t1.value), round(sum(t1.value)/sum(t2.total)*100,2)        
from t1,(select sum(value) as total from t1) t2
group by t1.rnum;

Can i achieve the same using some SQL Analytic function?

Thanks in advance.