SQL & PL/SQL

Hi All,

We have a requirement to create a report on few metrics.

Example

ORG COST_BY_ORG PERCENTAGE

FA1 total 100 14.29%
HG total 400 57.14%
JY total 200 28.57%

grand total: 700 100%

I was able to acheive till the totals by ORG. But not sure how I could include the percentage with in the same query.

Any ideas please!

Thanks,
Prathima