carllewis Posted October 24, 2021 Share Posted October 24, 2021 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 Link to comment Share on other sites More sharing options...
carllewis Posted October 24, 2021 Author Share Posted October 24, 2021 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] Link to comment Share on other sites More sharing options...
carllewis Posted October 27, 2021 Author Share Posted October 27, 2021 I managed to solve the issue, adding one more row group related to the bimesters.[/code] Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now