I am trying to sum the columns in a matrix and am having trouble with the
totals row.
I right-click the row group and click subtotals. This creates the Total row
just fine, with the â'Totalâ' cell directly under the row group cell. However,
the cell in the data column is inaccessible, so Iâ'm not sure how or where to
put the sum expression for the columns. I canâ't put it in the â'Totalâ' cell of
the totals row, as this would simply total all the data in the matrix without
regard to column group. So what I have is the 1st row values in the total
row. If I canâ't get to the column cell on the total row, where do I enter the
sum expression for the columns?
This has to be a simple thing, if someone can just point me in the right
direction.
Thanks.It's the expression in the data cell itself. There's no separate subtotal
function.
"David" wrote:
> I am trying to sum the columns in a matrix and am having trouble with the
> totals row.
> I right-click the row group and click subtotals. This creates the Total row
> just fine, with the â'Totalâ' cell directly under the row group cell. However,
> the cell in the data column is inaccessible, so Iâ'm not sure how or where to
> put the sum expression for the columns. I canâ't put it in the â'Totalâ' cell of
> the totals row, as this would simply total all the data in the matrix without
> regard to column group. So what I have is the 1st row values in the total
> row. If I canâ't get to the column cell on the total row, where do I enter the
> sum expression for the columns?
> This has to be a simple thing, if someone can just point me in the right
> direction.
> Thanks.
>
Monday, March 12, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment