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)?>