Matrix subtotal problem

Hi,

I have a matrix report like this,

　 Product 1 Product 2 Product 3 subtotal Dept A 　 　 　 　 Dept B 　 　 　 　 … 　 　 　 　 subtotal 　 　 　 　

for some issues, I must add a group filter to filter out some departments that I don't want to show them on this report (ex. Field!dept.value !="A"). Additionally, My users can input the date interval to query by report parameters. When the date interval user inputed only have Dept A data , the report return some error message(I have set the norows property to show "nodata" if there is no data meet the condition). But when I remove the subtotal ,it works and return "nodata" message. I think there's some problem with the subtotal, but I have no idea where to figure it out.

Anyone would give me a help ?!

First, I recommend to install SP1 of SQL Server 2005.

Regarding the filter on the group - it will only apply to the group data but no to the subtotal because the subtotal is not in the scope of the grouping. So if you want to really remove the values for certain groups and a subtotal is present, you should filter directly in the query, at the dataset level, or at the matrix level.

-- Robert

Matrix Drill down Value not Correct

I am making a report that has column groups Day of Week and then "late".
(early late ontime) Row groups consist of region,district,store,dept. The
value is the sum(Fields!Measures_Rec_Count.Value) and reflects the correct
numbers throughout the drilldown. I am having problems with the Ratio value
calculated as format(sum( Fields!Measures_Rec_Count.Value
,"matrix1_late_Late")/sum(Fields!Measures_Rec_Count.Value,
"matrix1_dow_Dow"),"#.#%")...this calculates the correct ratio for the top
level but remains the same throughout the drilldown...I have tried using the
InScope() function but not getting any positive results....
Any Ideas?
Sunday Monday
...etc
Early ontime late Early ontime
late
region 10(83%) 2(17%) 10(25%) 25(64%) 4(10%)
district 1 3(83%) 2(17%)
district 2 4(83%) (17%)
district 3 3(83%) (17%)still could not get dynamicly grouped columns and rows to drill down with the
correct numbers....altered my MDX to create a matrix with one dynamic column
and 3 static columns and the drill down works now.....If anyone knows of a
way to have multiple dynamic columns where calculated cells drill down with
correct values please let me know.
Thanks.
"Raz" wrote:
> I am making a report that has column groups Day of Week and then "late".
> (early late ontime) Row groups consist of region,district,store,dept. The
> value is the sum(Fields!Measures_Rec_Count.Value) and reflects the correct
> numbers throughout the drilldown. I am having problems with the Ratio value
> calculated as format(sum( Fields!Measures_Rec_Count.Value
> ,"matrix1_late_Late")/sum(Fields!Measures_Rec_Count.Value,
> "matrix1_dow_Dow"),"#.#%")...this calculates the correct ratio for the top
> level but remains the same throughout the drilldown...I have tried using the
> InScope() function but not getting any positive results....
> Any Ideas?
> Sunday Monday
> ...etc
> Early ontime late Early ontime
> late
> region 10(83%) 2(17%) 10(25%) 25(64%) 4(10%)
> district 1 3(83%) 2(17%)
> district 2 4(83%) (17%)
> district 3 3(83%) (17%)
>

Matrix - how to let column group stay in separate lines?

I would like to have this matrix format:
JAN-06 FEB-06 ... Total
Sales Dept 100 120 220
Team One 60 70 130
Emp A 30 35 65
Emp B 30 35 65
Team Two 40 50 90
Emp C 20 25 45
Emp D 20 25 45
The default layout is sales dept, team one, and employee are on the same
line, I would like them in separate line to save space.
Thanks in advance.Sorry, I mean row groups in separate lines
"qye2020" <qye2020@.yahoo.com> wrote in message
news:uUKfBjcTGHA.5468@.TK2MSFTNGP14.phx.gbl...
>I would like to have this matrix format:
> JAN-06 FEB-06 ... Total
> Sales Dept 100 120 220
> Team One 60 70 130
> Emp A 30 35 65
> Emp B 30 35 65
> Team Two 40 50 90
> Emp C 20 25 45
> Emp D 20 25 45
> The default layout is sales dept, team one, and employee are on the same
> line, I would like them in separate line to save space.
> Thanks in advance.
>|||I hope someone answers your question...I am trying to do something similar
also.
"qye2020" wrote:
> Sorry, I mean row groups in separate lines
> "qye2020" <qye2020@.yahoo.com> wrote in message
> news:uUKfBjcTGHA.5468@.TK2MSFTNGP14.phx.gbl...
> >I would like to have this matrix format:
> > JAN-06 FEB-06 ... Total
> > Sales Dept 100 120 220
> > Team One 60 70 130
> > Emp A 30 35 65
> > Emp B 30 35 65
> > Team Two 40 50 90
> > Emp C 20 25 45
> > Emp D 20 25 45
> >
> > The default layout is sales dept, team one, and employee are on the same
> > line, I would like them in separate line to save space.
> >
> > Thanks in advance.
> >
>
>