Forum Discussion
Table Visualization - Group By Field?
Try turning off "Stepped Layout" under "Row Headers" in your Matrix Visualization settings. Gets you pretty close to what you are looking for I think.
Use the matrix visual and drop Color, Make and Model into the row bucket. Expand the visualization using the buttons in the top left of the visual. You will get this:
If you really want the "Toyota | Highlander" rather than the per row format you would need to create a calculated column in your data table that combines Make and Model.
I suspected you could only create the view I need with a calculated field. I played with the Matrix view prior to posting my question, and ended up with the cascading rows as you demonstrated.
Right now I have two seperate tables creating the view I want, and I just have them sitting next to each other. Was hoping to join them as one continuous table, but for what I need, I may just have to keep them as seperate visualizations.
Try turning off "Stepped Layout" under "Row Headers" in your Matrix Visualization settings. Gets you pretty close to what you are looking for I think.
