https://community.qlik.com/t5/QlikView/Straight-Table-Columns/m-p/1602272#M736064 <P>hi,&nbsp;</P><P>im trying to create a straight table that has ITEM as a dimension, then each MONTH as an individual column, and sum(ITEM) beneath each of the months.&nbsp; however, when i try this im getting the months being listed vertically.&nbsp; i have a column MONTH with each of the months in it, is there a way to use each of the months as an individual column?</P><P>TIA</P> Sat, 16 Nov 2024 03:00:26 GMT anonymous1 2024-11-16T03:00:26Z https://community.qlik.com/t5/QlikView/Straight-Table-Columns/m-p/1602272#M736064 <P>hi,&nbsp;</P><P>im trying to create a straight table that has ITEM as a dimension, then each MONTH as an individual column, and sum(ITEM) beneath each of the months.&nbsp; however, when i try this im getting the months being listed vertically.&nbsp; i have a column MONTH with each of the months in it, is there a way to use each of the months as an individual column?</P><P>TIA</P> Sat, 16 Nov 2024 03:00:26 GMT https://community.qlik.com/t5/QlikView/Straight-Table-Columns/m-p/1602272#M736064 anonymous1 2024-11-16T03:00:26Z https://community.qlik.com/t5/QlikView/Straight-Table-Columns/m-p/1602286#M736065 <P>Yes you can create an expression for each month like this:</P><P>Sum( {&lt;MONTH={'Jan'}&gt;} Sales)<BR />...<BR />Sum( {&lt;MONTH={'Dec'}&gt;} Sales)</P><P>And if you have totals enabled for each expression and select the option to have the sum below you get what you want.</P> Mon, 15 Jul 2019 11:38:28 GMT https://community.qlik.com/t5/QlikView/Straight-Table-Columns/m-p/1602286#M736065 petter 2019-07-15T11:38:28Z