Developer6i: Dividing Matrix Report Cell Values by a summary

From: Aamir Abbas <aamir_abbas_at_intervoice.com>
Date: 19 Feb 2002 15:14:08 -0800
Message-ID: <1afdd75f.0202191514.6fc279e_at_posting.google.com>

Can someone please let me know if using Developer6i (Reports) it is possible to divide each value of a matrix report by the total for the row in which the value is found? For example:

If the report on the raw data looks like this:

    Fig 1

               Column->   C1    C2    C3    CT(Column Total)
            Row 
             R1           x1    x2    x3    T1
             R2           x4    x5    x6    T2
             R3           x7    x8    x9    T3

Where:

    Row Identifiers are:- R1, R2, R3
    Column Identifiers are:-  C1, C2, C3
    Cell Values are:- x1 thru x9, and
    Totals for each row (R1, R2, R3) are T1, T2, T3, respectively. 
       T1 = x1+x2+x3, T2=x4+x5+x6   T3=X7+x8+x9

In Developer6i (Reports), is it possible to divide each cell value in the above report by the total for that row to get something like the following?

    Fig 2

               Column-> C1' C2' C3' CT(Column Total)'

            Row 
             R1'           x1/T1    x2/T1    x3/T1        T1'
             R2'           x4/T2    x5/T2    x6/T2        T2'
             R3'           x7/T3    x8/T3    x9/T3        T3'

I am only interested in displaying the final result after computing x1/T1, etc.

Thanks in advance.

Aamir Received on Wed Feb 20 2002 - 00:14:08 CET