How to work with months as column headers

Question

Hi guys&nbsp;I have this type of a table:categorysubcategoryproductcolourJan-22Feb-22Mar-22Apr-22foodbeveragescoca colared&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 258&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 25&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 456&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I have no idea how to work with this type of table in Table View for, let's say, creating a table or a graph with the number of beverages sold every month.&nbsp;I have never worked with columns as months, just lines...&nbsp;Can you guys help out here?&nbsp;&nbsp;Thanks so much!

philiptreacy · Accepted Answer

Hi&nbsp;i_stanescu_ro&nbsp;
&nbsp;
You'll need to pivot the month columns into rows so that the data is structured in the proper way for reporting.
&nbsp;
Please provide some sample data so I can show you.
&nbsp;
regards
&nbsp;
Phil

Forum Discussion

How to work with months as column headers

2 Replies

Related content

Dynamic Column headers

Dynamic Column Header in Visualisation

Line Break in Table Column Headers

Customize Column header tooltip

Month/Year column

category	subcategory	product	colour	Jan-22	Feb-22	Mar-22	Apr-22
food	beverages	coca cola	red	120	258	25	456