What is the AGG(Students with...) field on the Rows? Is it a calculation? With ID on Columns, you are telling Tableau to give you a column for each ID. What happens if you remove ID from Columns?
It might be helpful to actually see some sample data in a packaged workbook. Would you be able to mock-up something similar to your case (even using the sample Superstore Sales data provided with Tableau)?:
Yes, its a calculation that defines the levels of absences. The other field, ID, is the students. I don't see how I'd replicate it with sample data on the fly, but I figured there was a simple way to get the total/summary of the groupings instead of the "1" for each match. Its not critical to do this, since its displayed properly in a graph, but I am trying to learn as much as possible. Filters are applied globally, so I cannot group the data (as far as I know) because the groups would change based on the filters displayed. I just thought there might be a simple way to fix this and provide the summary numbers.
I don't want to remove the students from the columns, but want to display the total # of students there instead of each individual student. I have tried sum, but it will just say "10+" and the total.
I am trying to translate this chart into the crosstab form:
Thanks! I will prepare some sample data if needed later.