CountDistinct in a Matrix Report

I have say 10 companies, each company has 2 activities against it. I build my
sql query and it contains the companyid and the activityid against each
record (20 records). I set up a matrix report to break the activities out by
month (created date) and activity type by adding Fields!ActivityID to the
detail section and this works fine. I then want another matrix underneath
that reports how many companies make up the first figure. I use
Countdistinct(Fields!CompanyID) in the detail section and add in subototals.
This report doesn't turn out as I want, the figures in the detail bit are
the same as the first report (they shoild be less), though the subtotal
reports correctly. Anyone know what I'm doing wrong.
Many ThanksSorry Ignore this, I'm being very silly!!
"Paul Whittaker" wrote:
> I have say 10 companies, each company has 2 activities against it. I build my
> sql query and it contains the companyid and the activityid against each
> record (20 records). I set up a matrix report to break the activities out by
> month (created date) and activity type by adding Fields!ActivityID to the
> detail section and this works fine. I then want another matrix underneath
> that reports how many companies make up the first figure. I use
> Countdistinct(Fields!CompanyID) in the detail section and add in subototals.
> This report doesn't turn out as I want, the figures in the detail bit are
> the same as the first report (they shoild be less), though the subtotal
> reports correctly. Anyone know what I'm doing wrong.
> Many Thanks