How to create summation column and total of a column in OBIEE Analysis?
878994Jan 28 2012 — edited Jan 30 2012Hi All,
My requirement is, Imagine I have a table which contains DEPTNO, DNAME, ENAME, EMPNO AND SAL. Under this table i need to display the count(EMPNO), Total SUM(SAL) and the entire table has to be grouped based on the DEPTNO.
For example, If the DEPTNO is 10. The records based on the DEPTNO has to be displayed as a separate table. And the successive DEPTNO's like 20 and 30 and their records also has to be displayed as separate tables. At the end of each table the DEPTNO and the count(EMPNO), Total SUM(SAL) has to be displayed is it possible.
If possible pls tell me how to do it in a stepwise manner. As i am new to OBIEE Anwers.
Thanks in Advance,
Thenmozhi