Does the matrix support the kind of expression that will allow repurposing
the the output of the matrix 'data' textbox based on the level at which a
secific grouping row is exposed.

More information:

Please refer to the following pseudo code expression as a starting point to
show what I would like to be able to achieve.

=Switch(Level = 0,Fields!data.Value
Level = 1,count(Fields!data.Value)/((First(Fields!stAssocCnt.Value)+0.0)),
Level = 2,count(Fields!data.Value)/((First(Fields!stAssocCnt.Value)+0.0)),
Level = 3,count(Fields!data.Value)/((First(Fields!stAssocCnt.Value)+0.0)),
Level = 4,count(Fields!data.Value)/((First(Fields!stAssocCnt.Value)+0.0)),
Level = 5,count(Fields!data.Value)/((First(Fields!stAssocCnt.Value)+0.0)))

The word "level" in the above 'code' is supposed to imply the use of the
level function. Even though it is my understanding that the level function
is only available for the table data region and we are discussing the matrix
in this question the use of the level function here roughtly demonstrates
what I want to achieve.

I also understand that my syntax for the use of the "level" function is not
correct (partially because it is used out of context) however the use above
does convey the concept of what I would like to be able to do - repurpose
the 'data' cell based on the level of the hierarchy which is exposed.

I am also not sure which level should be '0' the highest or the lowest - in
this example I am assuming that level '0' is the lowest level of the
hierarchy.

What is happening in the pseudo code above is that when a particular row is
fully expaneded what is displayed is the untouched field value as it is in
the underlying data table. When the first group is collapsed then the count
of cells within the group are divided by the first value in a named column.
The result is a percentage that has a particular meaning to this report.

Here are some sample data.

hdName,hdEnt,hdTCntAaB,dvName,dvEnt,dvTCntAaB,reName,reEnt,reTCntAaB,arName,arEnt,arTCntAaB,stName,stEnt,stAssocCnt,associateName,courseTitle,data
TKHdqtrs,26183,824,Division: 9480,88041,265,Region: 9460,96151,101,Area
9435,88630,44,TK#601,88083,4,FELIFRANCISCO,Brake Systems Service,87% score
TKHdqtrs,26183,824,Division: 9480,88041,265,Region: 9460,96151,101,Area
9435,88630,44,TK#601,88083,4,FELIFRANCISCO,Brake System Theory,80% score
TKHdqtrs,26183,824,Division: 9480,88041,265,Region: 9460,96151,101,Area
9435,88630,44,TK#601,88083,4,FELIFRANCISCO,Tire Service - Tire Repair
Procedures,100% score
TKHdqtrs,26183,824,Division: 9480,88041,265,Region: 9460,96151,101,Area
9435,88630,44,TK#601,88083,4,ALVAJULIO,Brake System Theory,80% score
TKHdqtrs,26183,824,Division: 9480,88041,265,Region: 9460,96151,101,Area
9435,88630,44,TK#601,88083,4,ALVAJULIO,Diagnosing Antilock Brake Systems,90%
score

What the calculation is doing is taking the count (aggregate count of text
entries) of persons who have taken a course and dividing it by the value
supplied by the query (the count of persons who are assigned to take a
course.

The end result is that at the lowest level you have the score of individual
persons (in text format) if they took the course and blanks if they have
not. Then as you successively collapse the grouping levels you get the
percentage of total persons who have taken the course at and below the
current level of the hierarchy who were assigned to take the course.

What is not obvious here is that he total counts in the data have come from
a separate query (built in a stored procedure) because the primary query (by
requirement) filters out those persons who have not taken any of the courses
selected for display  in the report.

The question I need answered is: Is there a way to detect for a particular
data cell what level of the hierarchy the user has selected to expose and
use that information in an expression entered in the 'data' text box of the
matrix data region?

Thank you,
Doug