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.