Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Displaying total count in a pie or bar graph

mojofilterAug 10 2006 — edited Aug 14 2006
Is it possible to display the sum total of all figures displayed in a pie or bar graph?

Example:

SELECT null, ename, sal
FROM scott.emp
WHERE deptno = :P101_DEPTNO

returns

ename sal
---------------
SCOTT 25000
JOHN 1000
FRANK 2000
TONY 300

I want to place the sum of the column sal in the graph somewhere...

A text string like "28300 is the total for all salaries"

Is such a thing possible?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 11 2006
Added on Aug 10 2006
6 comments
933 views