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