ORACLE BI PUBLISHER

A. Please learn the steps of creating Matrix report from previous video

B. Now we will discuss about Position, Sorting, 


1. Position: 

<?position()?>


2. Sorting: 

<?sort:DNAME;'ascending'?><?DNAME?> 

<?sort:JOB;'ascending';data-type='text'?><?JOB?> 


3. Horizotal group Total 

<?sum(current-group()/EMP)?>


4. Vertical group Total

<?for-each-group@cell://G_DNAME;./JOB?>  

<?sum(current-group()/EMP)?>


5. Grant Total 

<?sum(EMP)?>