Calculation in Matrix

My Matrix has the following structure
Item Jan Feb
--
AAA 200 40
How would I add another column to show the diff. between the two months
Item Jan Feb Diff
--
AAA 200 40 160
Thanks,
JRI don't think you can accomplish this currently with a matrix. As you know,
with a table it is easy but that fixes the number of displayed columns unlike
a matrix. Note that your question is similar to the one posted yesterday
about adding a partial subtotal to a matrix. There were no answers to that
question.
"John" wrote:
> My Matrix has the following structure
> Item Jan Feb
> --
> AAA 200 40
>
> How would I add another column to show the diff. between the two months
> Item Jan Feb Diff
> --
> AAA 200 40 160
>
> Thanks,
> JR|||Substraction is negative addition. Display Feb as 20 but treat it as -20 and
calculate the total.
CD
"B. Mark McKinney" <BMarkMcKinney@.discussions.microsoft.com> wrote in
message news:714B0E8B-B6C4-488B-9DE5-9DA23AD83E39@.microsoft.com...
>I don't think you can accomplish this currently with a matrix. As you know,
> with a table it is easy but that fixes the number of displayed columns
> unlike
> a matrix. Note that your question is similar to the one posted yesterday
> about adding a partial subtotal to a matrix. There were no answers to that
> question.
> "John" wrote:
>> My Matrix has the following structure
>> Item Jan Feb
>> --
>> AAA 200 40
>>
>> How would I add another column to show the diff. between the two months
>> Item Jan Feb Diff
>> --
>> AAA 200 40 160
>>
>> Thanks,
>> JR