Developer6i: Dividing matrix report cell values by a summary value

From: Aamir Abbas <aamir_abbas_at_intervoice.com>
Date: 19 Feb 2002 14:42:14 -0800
Message-ID: <1afdd75f.0202191442.5a0f6d1_at_posting.google.com>


Schema:	SCOTT						
Table:	EMP						
		               MATRIX REPORT				
							
Fig 1	Actual values from the EMP table

JOB	ANALYST	CLERK	MANAGER	PRESIDENT	SALESMAN	TOTAL	
DEPTNO							
10		 1,300 	 2,450 	 5,000 		                8,750 	
20	 6,000 	 1,900 	 2,975 			               10,875 	
30		 950 	 2,850 		           5,600        9,400 	
  total: 6,000 	 4,150 	 8,275 	 5,000 	           5,600       29,025 	
							
							
Fig 2	The computations for the output look somewhat like the fig below
        where each cell value of the report in fig 1 is divided by the
        total sum of the values of that row.

JOB	ANALYST	     CLERK	MANAGER	    PRESIDENT	SALESMAN
DEPTNO							
10	         1300/8750    2450/8750     5000/8750
20   6000/10875 1900/10875   2975/10875 				
30		 950/9400     2850/9400                5600/9400 		
							

Is this possible in Developer6i? How? Received on Tue Feb 19 2002 - 23:42:14 CET

Original text of this message