Ref. Matrix totals in another Matrix

Hi All,
I realize that there are countless postings on Matrix totals, but I haven't
found a posting that specifically relates to what I'm trying to accomplish.
What I want to do is reference the calculated totals from one matrix in
another matrix. I don't know if this is even possible, but here's the what
I'm aiming for:
DATE Total Dept. 1 Dept. 2 Dept. 3 .....
Jan. 01 8 1 4 3
Jan. 02 10 2 3 5
Jan. 03 11 3 6 2
...
Jan. 31 9 2 2 5
---
MTD 38 8 15 15
Target 45 15 15 15 .....
Prev. Mon.51 14 18 19
Diff. -13 -6 -3 -4
Perc. 74.5% 57% 83% 78.9%
The MTD row is the Month To Date total for the first matrix (calculated
automatically using 'Subtotal'). Below that is the second matrix used to show
statistics. The reason I'm using a second matrix is because the number of
Departments is not a constant, so the bottom matrix needs the same number of
columns as the top matrix. (I'm using the same criteria for the "Columns",
and then just hiding it.)
The problem is, for the calculations in the bottom matrix, I need to know
the individual totals in each MTD cell in the above matrix, not just the
grand total. Is it possible to access those fields from the expression of a
cell in the bottom matrix (I.E. use the MTD total for Dept. 2 to calculate
the difference between the current month and the previous month in the lower
matrix)?
If not, then that leads me to believe I have the wrong approach to this
problem, and if that's the case, then how else would this be achieved?
Thanks very much in advance.
Martin McCarthyHas anybody come across a situation like this before? Any input would be
appreciated.
Thanks,
Martin
"Joseph Rea, Accord Software" wrote:
> Hi All,
> I realize that there are countless postings on Matrix totals, but I haven't
> found a posting that specifically relates to what I'm trying to accomplish.
> What I want to do is reference the calculated totals from one matrix in
> another matrix. I don't know if this is even possible, but here's the what
> I'm aiming for:
> DATE Total Dept. 1 Dept. 2 Dept. 3 .....
> Jan. 01 8 1 4 3
> Jan. 02 10 2 3 5
> Jan. 03 11 3 6 2
> ...
> Jan. 31 9 2 2 5
> ---
> MTD 38 8 15 15
>
> Target 45 15 15 15 .....
> Prev. Mon.51 14 18 19
> Diff. -13 -6 -3 -4
> Perc. 74.5% 57% 83% 78.9%
>
> The MTD row is the Month To Date total for the first matrix (calculated
> automatically using 'Subtotal'). Below that is the second matrix used to show
> statistics. The reason I'm using a second matrix is because the number of
> Departments is not a constant, so the bottom matrix needs the same number of
> columns as the top matrix. (I'm using the same criteria for the "Columns",
> and then just hiding it.)
> The problem is, for the calculations in the bottom matrix, I need to know
> the individual totals in each MTD cell in the above matrix, not just the
> grand total. Is it possible to access those fields from the expression of a
> cell in the bottom matrix (I.E. use the MTD total for Dept. 2 to calculate
> the difference between the current month and the previous month in the lower
> matrix)?
> If not, then that leads me to believe I have the wrong approach to this
> problem, and if that's the case, then how else would this be achieved?
>
> Thanks very much in advance.
> Martin McCarthy