RATIO_TO_REPORT « Analytical Functions « Oracle PL / SQL

2.RATIO_TO_REPORT can easily be partioned as well
3.Portion amounts add to 1.000 in each region
4.Notice that the PORTION column adds up to 100%
5.RATIO_TO_REPORT, break on and compute
6.RATIO_TO_REPORT(): compute the ratio of a value to the sum of a set of values