Oracle® Business Intelligence Discoverer Plus User's Guide
10g Release 2 (10.1.2.0.0) Part No. B13915-01 |
|
![]() Previous |
![]() Next |
Percentages are worksheet items that enable you to quickly and easily calculate percentages of rows and columns. For example, to calculate monthly profit figures as a percentage of the annual profit figure.
The figure below shows a worksheet containing a percentage item called 'Percentage of annual profit'. From this column you can see that the Video Rental department in the Central region contributed 8% of the annual profit total (i.e. $25,157).
Figure 15-1 A Discoverer worksheet with a percentage item (Percentage of annual profit)
Notes
You can also use Discoverer totals or calculations to calculate percentages (for more information, see "How to create totals" and "How to create calculations").
When you have defined percentages, you can use them in worksheets just like other items. For example, you can display or hide percentages on worksheets.