Displaying total count in a pie or bar graph
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