Create multiple rows within a crosstab column

[carllewis]

Goodnight.Is it possible to re-split a crosstab column to present a mini table with up to 4 rows and 3 columns?I need to display the grades, the number of absences and the bimester of students at a school, in sql I bring all this data and set up the report with the crosstab, however, I'm not able to make this arrangement in the column.To make it easier to understand, I included an image of the crosstab (cross01.png) that I created in the column marked in red. student has the information related to these data (bimester, grade and absence) I would like to present this line as exemplified in the example.pg image.In the sqlcross.png image I show how the data that feeds the crosstab are presented, in the red rectangle are the data I would like to show inside the crosstab column in the same order presented in the figure.In crosstab is it possible to do this?Carlos Henrique

 

[carllewis]

The desired situation image was made in Excel to show how I would like the final result of my crosstab. And the second image is how the crosstab is currently showing the data.[/code]

 

[carllewis]

I managed to solve the issue, adding one more row group related to the bimesters.[/code]