Calculating a delta in a matrix

I'm converting a pivot table spreadsheet to a RS matrix. I'm have a problem
figuring out how to calculate a delta column in the matrix. The delta is the
difference of current to prior for hot and cold by type. The RS matrix has a
column and row subtotal and a column grand total. I could do the calculation
in the SQL statement. Any ideas/solutions on how to do it in the RS matrix?
The last three columns are what i need to get into the matrix.
Current Current Sum Prior Prior Sum Delta Total Delta
Type Strategy Code Hot Cold Hot Cold Hot Cold
OTHR IAG 5 10 15 6 12 18 (1) (2) (3)
MNP 10 22 32 11 25 36 (1) (3) (4)
OTHR Total 15 32 47 17 37 54 (2) (5) (7)
XFOR IAG 20 40 60 22 45 67 (2) (5) (7)
SBF 25 55 80 27 60 87 (2) (5) (7)
XFOR Total 45 95 140 51 105 156 (4) (10) (14)
Grand Total 60 127 187 68 142 210 (6) (15) (21)Here's a better picture of the matrix
Cur CurSum Prior Prior Sum Delta Delta
Type Str Hot Cold Hot Cold Hot Cold
OTHR IAG 5 10 15 6 12 18 (1) (2) (3)
MNP 10 22 32 11 25 36 (1) (3) (4)
OTHR Total 15 32 47 17 37 54 (2) (5) (7)
XFOR IAG 20 40 60 22 45 67 (2) (5) (7)
SBF 25 55 80 27 60 87 (2) (5) (7)
XFOR Total 45 95 140 51 105 156 (4) (10) (14)
Grand Total 60 127 187 68 142 210 (6) (15) (21)
"dbro101" wrote:
> I'm converting a pivot table spreadsheet to a RS matrix. I'm have a problem
> figuring out how to calculate a delta column in the matrix. The delta is the
> difference of current to prior for hot and cold by type. The RS matrix has a
> column and row subtotal and a column grand total. I could do the calculation
> in the SQL statement. Any ideas/solutions on how to do it in the RS matrix?
> The last three columns are what i need to get into the matrix.
> Current Current Sum Prior Prior Sum Delta Total Delta
> Type Strategy Code Hot Cold Hot Cold Hot Cold
> OTHR IAG 5 10 15 6 12 18 (1) (2) (3)
> MNP 10 22 32 11 25 36 (1) (3) (4)
> OTHR Total 15 32 47 17 37 54 (2) (5) (7)
> XFOR IAG 20 40 60 22 45 67 (2) (5) (7)
> SBF 25 55 80 27 60 87 (2) (5) (7)
> XFOR Total 45 95 140 51 105 156 (4) (10) (14)
> Grand Total 60 127 187 68 142 210 (6) (15) (21)
>|||I have a very similar issue, as posted on 5th July, "Calculations in Matrix
report"
It would appear a delta cannot be calculated within a Matrix. My issue is
currently being investigated to determine whether there is a workaround.
Pete
"dbro101" <dbro101@.discussions.microsoft.com> wrote in message
news:8FA5FF70-523E-4354-80B8-4B94F694E6F2@.microsoft.com...
> Here's a better picture of the matrix
>
> Cur CurSum Prior Prior Sum Delta Delta
> Type Str Hot Cold Hot Cold Hot Cold
> OTHR IAG 5 10 15 6 12 18 (1) (2) (3)
> MNP 10 22 32 11 25 36 (1) (3) (4)
> OTHR Total 15 32 47 17 37 54 (2) (5) (7)
> XFOR IAG 20 40 60 22 45 67 (2) (5) (7)
> SBF 25 55 80 27 60 87 (2) (5) (7)
> XFOR Total 45 95 140 51 105 156 (4) (10) (14)
> Grand Total 60 127 187 68 142 210 (6) (15) (21)
> "dbro101" wrote:
>> I'm converting a pivot table spreadsheet to a RS matrix. I'm have a
>> problem
>> figuring out how to calculate a delta column in the matrix. The delta is
>> the
>> difference of current to prior for hot and cold by type. The RS matrix
>> has a
>> column and row subtotal and a column grand total. I could do the
>> calculation
>> in the SQL statement. Any ideas/solutions on how to do it in the RS
>> matrix?
>> The last three columns are what i need to get into the matrix.
>> Current Current Sum Prior Prior Sum Delta Total Delta
>> Type Strategy Code Hot Cold Hot Cold Hot Cold
>> OTHR IAG 5 10 15 6 12 18 (1) (2) (3)
>> MNP 10 22 32 11 25 36 (1) (3) (4)
>> OTHR Total 15 32 47 17 37 54 (2) (5) (7)
>> XFOR IAG 20 40 60 22 45 67 (2) (5) (7)
>> SBF 25 55 80 27 60 87 (2) (5) (7)
>> XFOR Total 45 95 140 51 105 156 (4) (10) (14)
>> Grand Total 60 127 187 68 142 210 (6) (15) (21)