Matrix Reprt Drill Through

Hi:
I wonder is there anyway I can show all items in a grouped level in a
cross-tab report with one click of a button (or an action)? The report is
query based.
For example, I have 10 stores and I want the user to be able to click a
botton and see all the customers in the 10 stores instead of clicking one by
one.
--
AraleHelo Arale,
What is a botton? Is that Chinese for button? Plewse spell better.
"Arale" wrote:
> Hi:
> I wonder is there anyway I can show all items in a grouped level in a
> cross-tab report with one click of a button (or an action)? The report is
> query based.
> For example, I have 10 stores and I want the user to be able to click a
> botton and see all the customers in the 10 stores instead of clicking one by
> one.
> --
> Arale

matrix column totals and the total row

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.
>