(Please draw this on your paper (as this editor is deleting all my spaces) to geta clear PICTURE...i've added -- before each value)
I'm required to generate a complicated Matrix Report. Having the following Output.
Note that * means a NULL value.
01,03,04 are GP values
CII, OSS, DROPSHIP are INV_ORG Values
COUGAR,NIPPON, HT-DIV are SUB_INV Values.


GP-0 (First Digit)

(Subinventories)
(Group) --(inv_org) -- COUGAR -- NIPPON -- HT-DIV --> GPXX TOTAL
GP 01 --CII -- 5 -- 2 --* -- 7
--OSS * --3 --4 -- 7
--DROPSHIP -- 6 -- * -- * -- 6
GP 03 --CII -- 5 -- * -- * --5
M1 --1 --11 -- * -- 12
DROPSHIP
GP 04 CII -- * -- * --3 -- 3
OSS --2 --9 -- * -- 11
DROPSHIP -- 1 --* --* -- 1

-------------------------------------------------------
CII Total 10 2 3
OSS Total 2 12 4
M1 Total 1 11
DROPSHIP Total 7
-------------------------------------------------------
The 2nd Page will have GP - 1 (first Digit) - The INV_ORG Totals for each SUBINV category are irrespective of GP's 2nd digit.

I've been able to generate the Inside matrix but not these TOTALS - which are individual totals for Inventory-orgs for each SUB_INV.

Do i need another matrix for the Data provided within the dotted lines ---.

Even if I use another matrix to generate these totals (data within the lines), I dont know how to show these 2 matrices together in the layout. Shall I use Data-links, if yes How ??
Plz HELP !!!

PS: While the First Matrix uses GP and INV_ORG as the first group(row-group of the matrix), Sub-Inv as the column-group.
The 2nd Matrix (if used) uses Inv_Org as the row-group, Sub-Inv as the column-group.