Overwriting Dimensions Binding Measure in Crosstab

I am wondering how to overwrite a crosstab in such a way that a measure is only bound to one dimension even though there are several. I want the crosstab to organize the players and positions as it appears, but I need to see all of the minutes played by each player on each row(when it would not normally show up it will be grey).
 
There is an attached xls file (

Find more posts tagged with

Comments

Clement Wong

Will need some more infoâ€¦ Do we have the sample source data (not the left side crosstab), but the actual data set that is being returned? Also, what is the data source origin â€“ database, CSV, etcâ€¦? The reason is that there could other alternatives to the solution based on these answers. 
What version of BIRT is being used? Open source, or commercial? 
Do we have the .rptdesign that produces the left side? 
Would that crosstab be the best way to visualize the # of minutes of each player played per game? Option 1: Size of dots could represent minutes, and the color could reflect (% of minutes play out of total minutes per game). Option 2: Spark bar, with one color for the amount of time played, and a grey for those duplicates?

SoccerMZG

Hi Clement, 
The data here is just an example of what I am trying to achieve. Here is a tabular version of the data (

SoccerMZG

Sorry, I do not think I attached the most up to date .xlsx file. Here it is:

Clement Wong

Mark,
 
I changed the expression of the "CrosstabPosition" to:
 
reportContext.evaluate("dimension");
 
The alternative is to save the [Position1] in the onCreate event, and use that variable in the expression of Crosstab Position.
 
The attached .rptdesign appears to be the output you are expecting using the first option. Don't forget to change the Data Source location in my .rptdesign if you run the attached.