https://community.qlik.com/t5/QlikView/Straight-table-with-Month-in-column/m-p/1735228#M506397 <P>Hi i need to put a table like this, with in column my month (field MESE_COMPETENZA)</P><P>and in my row my field AGENZIA</P><P>tha value is CONSUMO_SMC</P><P>How can i do that?</P><P>Thanks</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="danosoft_0-1597235610428.png" style="width: 810px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/38900iFE993F11F68171DC/image-dimensions/810x339?v=v2" width="810" height="339" role="button" title="danosoft_0-1597235610428.png" alt="danosoft_0-1597235610428.png" /></span></P><P>&nbsp;</P> Wed, 12 Aug 2020 12:34:28 GMT danosoft 2020-08-12T12:34:28Z https://community.qlik.com/t5/QlikView/Straight-table-with-Month-in-column/m-p/1735228#M506397 <P>Hi i need to put a table like this, with in column my month (field MESE_COMPETENZA)</P><P>and in my row my field AGENZIA</P><P>tha value is CONSUMO_SMC</P><P>How can i do that?</P><P>Thanks</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="danosoft_0-1597235610428.png" style="width: 810px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/38900iFE993F11F68171DC/image-dimensions/810x339?v=v2" width="810" height="339" role="button" title="danosoft_0-1597235610428.png" alt="danosoft_0-1597235610428.png" /></span></P><P>&nbsp;</P> Wed, 12 Aug 2020 12:34:28 GMT https://community.qlik.com/t5/QlikView/Straight-table-with-Month-in-column/m-p/1735228#M506397 danosoft 2020-08-12T12:34:28Z https://community.qlik.com/t5/QlikView/Straight-table-with-Month-in-column/m-p/1735447#M506398 <P>try like that:</P><P>- create a diagram &gt; pivot table</P><P>- add 2 dimensions&nbsp;<SPAN>AGENZIA &amp;&nbsp;MESE_COMPETENZA</SPAN></P><P><SPAN>- add expression sum(CONSUMO_SMC)</SPAN></P><P><SPAN>- drag and drop the month dimension to the top</SPAN></P><P><SPAN>- i think you want to tick the checkbox&nbsp; "Always Fully Expanded" on presentation tab</SPAN></P><P><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="drag_pivot.png" style="width: 399px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/38939i3DBD3148DF35E5A0/image-size/large?v=v2&amp;px=999" role="button" title="drag_pivot.png" alt="drag_pivot.png" /></span></SPAN></P><P>&nbsp;</P><P>&nbsp;</P> Thu, 13 Aug 2020 05:38:01 GMT https://community.qlik.com/t5/QlikView/Straight-table-with-Month-in-column/m-p/1735447#M506398 zhadrakas 2020-08-13T05:38:01Z