Forum Discussion
Post PartisanHow to create merged column headers in Matrix visual?
I would like to create a Matrix visual that looks like below where I have merged column headers (cars, trucks, suv's).
How can I add the merged headers?
Do those tables share the same structure? If they do, it would be better to combine them into a single table with an additional column to indicate the vehicle type. You can use the append feature in the query editor.
5 Replies
ERingMy data for each category (cars, trucks, & suv's) are in different tables. So I have a "cars" table, a "trucks" table, and an "suv" table.
I don't have a column that stores "car, truck, suv" values.
- danextian
Super User
Do those tables share the same structure? If they do, it would be better to combine them into a single table with an additional column to indicate the vehicle type. You can use the append feature in the query editor.
- parry2k
I wish you have explained it upfront. Better to combine (append) these tables as one table and then use what I suggested in my original reply.
