sql server reporting services: Matrix Drill down Value not Correct -- sql server reporting services

Matrix Drill down Value not Correct

Raz
6/26/2006 6:04:02 AM

sql server reporting services: 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%)

RE: Matrix Drill down Value not Correct

Raz
6/26/2006 7:52:01 AM

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.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.