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