Forum Discussion
Header For A Multiple Columns
Hi All,
My requirement is I need a header for some particular columns in a table. For example, if I have an area and country column means it shows under the Region header. How can I achieve this one?.
Sample data:
From this
| Product Code | Jan | Feb | Mar | Apr | May | Jun | Oct | Nov | Dec | Area | Country |
| A | 200 | 100 | 300 | 400 | 200 | 100 | 100 | 300 | 400 | APAC | Taiwan |
| B | 30 | 50 | 75 | 10 | 30 | 50 | 50 | 75 | 10 | APAC | Turkey |
| C | 60 | 28 | 11 | 87 | 60 | 28 | 28 | 11 | 87 | China | China |
| A | 40 | 64 | 3 | 90 | 40 | 64 | 64 | 3 | 90 | SAM | Argentina |
| A | 34 | 69 | 58 | 48 | 34 | 69 | 69 | 58 | 48 | SAM | Mexico |
| B | 56 | 72 | 32 | 81 | 56 | 72 | 72 | 32 | 81 | EMEA | Saudi Arabia |
| C | 76 | 31 | 14 | 5 | 76 | 31 | 31 | 14 | 5 | APAC | Thailand |
To this:
Thanks in advance.
1 Reply
Shreeram04 in your visual you are having i guess sales by month and then you wish to add another value of text type i.e.e area and country is not possible. matrix visual will show first value against all header which is month case and if you add another value that will also be shown against all headers which will not give the correct result.
in this case, you can either use textbox or reactangle shape to show header for last two columns and seperate header for month values. this is the quick workaround solution that can be used for now.
also, were you able to create the first visual that you have shared above
