Adding more advanced totalling columns

Hi,
I want to add some two columns that flank the totalling columns and derive
their values from the figures in the totalling columns. Doesn't seem to be
to easy though. Do I really have to run through the dataset, to grab each
total of each row / column, then set variables for the figures I that must
populate the two flanking columns? Basically:
Group1
Column1 Column2 Total1 Total2 My_Col1
My_Col2
Row 21 19 21 19
2 110.5%
What I am seeing is I have to create another Matrix that has only two
columns in one group and hidden rows, push it up against the right hand side
of the first matrix, and populate it with the figures calculated as
explained above.
TIA,
JarrydLets try that example again:
Group1
Col1 Col2 Total1 Total2 My_Col1 My_Col2
Row 21 19 21 19 2
110.5%
I hope this one looks a bit more intelligible.
Jarryd
"Jarryd" <jarryd@.community.nospam> wrote in message
news:eoMa9sRzHHA.5408@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I want to add some two columns that flank the totalling columns and derive
> their values from the figures in the totalling columns. Doesn't seem to
> be to easy though. Do I really have to run through the dataset, to grab
> each total of each row / column, then set variables for the figures I that
> must populate the two flanking columns? Basically:
> Group1
> Column1 Column2 Total1 Total2 My_Col1
> My_Col2
> Row 21 19 21 19 2
> 110.5%
> What I am seeing is I have to create another Matrix that has only two
> columns in one group and hidden rows, push it up against the right hand
> side of the first matrix, and populate it with the figures calculated as
> explained above.
> TIA,
> Jarryd
>|||Hello Jarryd,
As I have mentioned in the previous issue, Matrix did not support to add
additional column. We may need to add additional table beside the matrix.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Dear Wei,
Sorry to be a pain. It just seems a bit tedious.
Jarryd
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:0g%23iyHazHHA.4844@.TK2MSFTNGHUB02.phx.gbl...
> Hello Jarryd,
> As I have mentioned in the previous issue, Matrix did not support to add
> additional column. We may need to add additional table beside the matrix.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello Jarryd,
Thank you for your understanding. You could send your feedback to the
product team.
http://connect.microsoft.com/sql
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.