Drillthrough from matrix subtotal value

I've got a matrix as shown below:
c1 c2 Total
r1 1 2 3
r2 4 5 9
Total 5 7 12
I've set the matrix up to drillthrough to a report when I click on the cell values. But I'm having a problem getting the right results when I click on the subtotal values. I'd like to be able to click on (for example) 9 and get a got to the report getting all detail for r2 regarless of the column group. Ditto for rows if I click on a column subtotal. And I'd like to get a complete detail report if I click on 12. However, I'm not sure how to set up the drillthrough on the cell to make this happen. And it doesn't appear to be possible to set up a different drillthrough on the subtotal row/column as you cannot access their properties explicitly.Take a look at the InScope function. It was designed with this scenario in
mind. There should be an example of exactly this usage in the
documentation.
--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"virtualfergy" <virtualfergy@.discussions.microsoft.com> wrote in message
news:4D5302B1-6768-4E24-83BE-F16665CF7B2A@.microsoft.com...
> I've got a matrix as shown below:
> c1 c2 Total
> r1 1 2 3
> r2 4 5 9
> Total 5 7 12
> I've set the matrix up to drillthrough to a report when I click on the
cell values. But I'm having a problem getting the right results when I click
on the subtotal values. I'd like to be able to click on (for example) 9 and
get a got to the report getting all detail for r2 regarless of the column
group. Ditto for rows if I click on a column subtotal. And I'd like to get a
complete detail report if I click on 12. However, I'm not sure how to set up
the drillthrough on the cell to make this happen. And it doesn't appear to
be possible to set up a different drillthrough on the subtotal row/column as
you cannot access their properties explicitly.|||Thanks Chris. That worked great. I looked at InScope at first but I didn't understand its purpose correctly. Not it makes perfect sense.
"Chris Hays [MSFT]" wrote:
> Take a look at the InScope function. It was designed with this scenario in
> mind. There should be an example of exactly this usage in the
> documentation.
> --
> My employer's lawyers require me to say:
> "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> "virtualfergy" <virtualfergy@.discussions.microsoft.com> wrote in message
> news:4D5302B1-6768-4E24-83BE-F16665CF7B2A@.microsoft.com...
> > I've got a matrix as shown below:
> >
> > c1 c2 Total
> > r1 1 2 3
> > r2 4 5 9
> > Total 5 7 12
> >
> > I've set the matrix up to drillthrough to a report when I click on the
> cell values. But I'm having a problem getting the right results when I click
> on the subtotal values. I'd like to be able to click on (for example) 9 and
> get a got to the report getting all detail for r2 regarless of the column
> group. Ditto for rows if I click on a column subtotal. And I'd like to get a
> complete detail report if I click on 12. However, I'm not sure how to set up
> the drillthrough on the cell to make this happen. And it doesn't appear to
> be possible to set up a different drillthrough on the subtotal row/column as
> you cannot access their properties explicitly.
>
>|||Can u share the example. Please.
"virtualfergy" wrote:
> I've got a matrix as shown below:
> c1 c2 Total
> r1 1 2 3
> r2 4 5 9
> Total 5 7 12
> I've set the matrix up to drillthrough to a report when I click on the cell values. But I'm having a problem getting the right results when I click on the subtotal values. I'd like to be able to click on (for example) 9 and get a got to the report getting all detail for r2 regarless of the column group. Ditto for rows if I click on a column subtotal. And I'd like to get a complete detail report if I click on 12. However, I'm not sure how to set up the drillthrough on the cell to make this happen. And it doesn't appear to be possible to set up a different drillthrough on the subtotal row/column as you cannot access their properties explicitly.

Drill Through to report from Matrix Subtotal

Hi,
I have the following result from a matrix:
| Week 1 | Week 2 | Week 3 |
DSM 1 | Salesrep 1| Sales | $100 | $200 | $300 |
|New cust | 3 | 2 |
5 |
Salesrep 2| Sales | $200 | $300 | $100 |
|New cust | 2 | 1 |
3 |
---
DSM 1 Totals | $300 | $500 | $400 |
|New cust | 5 | 3 |
8 |
What I'm trying to accomplish is to have the user click on the field "New
Cust" and open a report that shows the new customers (detail) for the entire
row. The marix report has to and from date parameters that I am passing to
the second report, but the second report also has the DSM and Salesrep
parameters (each set up as a multi parameter). I want the user to be able to
click on the indevidual Salesrep line, the DSM subtotal Line, and the Grand
total line. I know this requires the InScope function, but I can't seem to
get the statment right.
Any help is greatly appreciated.
Thanks!
--
JohnWell either this was too hard or it is not possible. Either way, can someone
give me some insight?
--
John
"John" wrote:
> Hi,
> I have the following result from a matrix:
> | Week 1 | Week 2 | Week 3 |
> DSM 1 | Salesrep 1| Sales | $100 | $200 | $300 |
> |New cust | 3 | 2 |
> 5 |
> Salesrep 2| Sales | $200 | $300 | $100 |
> |New cust | 2 | 1 |
> 3 |
> ---
> DSM 1 Totals | $300 | $500 | $400 |
> |New cust | 5 | 3 |
> 8 |
> What I'm trying to accomplish is to have the user click on the field "New
> Cust" and open a report that shows the new customers (detail) for the entire
> row. The marix report has to and from date parameters that I am passing to
> the second report, but the second report also has the DSM and Salesrep
> parameters (each set up as a multi parameter). I want the user to be able to
> click on the indevidual Salesrep line, the DSM subtotal Line, and the Grand
> total line. I know this requires the InScope function, but I can't seem to
> get the statment right.
> Any help is greatly appreciated.
> Thanks!
> --
> John