https://community.qlik.com/t5/App-Development/Total-for-each-Date-in-pivot-table/m-p/2500655#M103183 <P>Try&nbsp;<FONT face="courier new,courier"><SPAN>Sum(TOTAL &lt;Type&gt; Value)</SPAN></FONT></P> Thu, 09 Jan 2025 16:01:12 GMT henrikalmen 2025-01-09T16:01:12Z https://community.qlik.com/t5/App-Development/Total-for-each-Date-in-pivot-table/m-p/2500643#M103179 <P>I need to sum(value) for each date in pivot table</P> <P>Data I got, rows is 'Type', columns is 'Date', measure is 'Sum(Value)'</P> <TABLE width="326"> <TBODY> <TR> <TD width="83">&nbsp;</TD> <TD colspan="2" width="243">Date</TD> </TR> <TR> <TD>Type</TD> <TD>01.01.2025</TD> <TD>02.01.2025</TD> </TR> <TR> <TD>A</TD> <TD>1</TD> <TD>2</TD> </TR> <TR> <TD>B</TD> <TD>2</TD> <TD>4</TD> </TR> <TR> <TD>C</TD> <TD>3</TD> <TD>6</TD> </TR> <TR> <TD>TOTAL</TD> <TD>6</TD> <TD>12</TD> </TR> </TBODY> </TABLE> <P>Output I need :</P> <TABLE width="325px"> <TBODY> <TR> <TD width="80.7344px">&nbsp;</TD> <TD width="91.0781px">01.01.2025</TD> <TD width="152.188px">02.01.2025</TD> </TR> <TR> <TD width="80.7344px">A</TD> <TD width="91.0781px">6</TD> <TD width="152.188px">12</TD> </TR> <TR> <TD width="80.7344px">B</TD> <TD width="91.0781px">6</TD> <TD width="152.188px">12</TD> </TR> <TR> <TD width="80.7344px">C</TD> <TD width="91.0781px">6</TD> <TD width="152.188px">12</TD> </TR> <TR> <TD width="80.7344px">TOTAL</TD> <TD width="91.0781px">6</TD> <TD width="152.188px">12</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>What I tried :</P> <TABLE width="1293"> <TBODY> <TR> <TD width="83">&nbsp;</TD> <TD colspan="4" width="605">01.01.2025</TD> <TD colspan="4" width="605">02.01.2025</TD> </TR> <TR> <TD>Type</TD> <TD>Sum(Value)&nbsp;</TD> <TD>&nbsp;Sum({&lt;[Type]=&gt;} Value)</TD> <TD>&nbsp;Sum(TOTAL &lt;Date&gt; Value)</TD> <TD>aggr(Sum(Value), Date)&nbsp;</TD> <TD>Sum(Value)&nbsp;</TD> <TD>&nbsp;Sum({&lt;[Type]=&gt;} Value)</TD> <TD>&nbsp;Sum(TOTAL &lt;Date&gt; Value)</TD> <TD>aggr(Sum(Value), Date)&nbsp;</TD> </TR> <TR> <TD>A</TD> <TD>1</TD> <TD>1</TD> <TD>18</TD> <TD>-</TD> <TD>2</TD> <TD>2</TD> <TD>18</TD> <TD>12</TD> </TR> <TR> <TD>B</TD> <TD>2</TD> <TD>2</TD> <TD>18</TD> <TD>-</TD> <TD>4</TD> <TD>4</TD> <TD>18</TD> <TD>12</TD> </TR> <TR> <TD>C</TD> <TD>3</TD> <TD>3</TD> <TD>18</TD> <TD>6</TD> <TD>6</TD> <TD>6</TD> <TD>18</TD> <TD>12</TD> </TR> <TR> <TD>TOTAL</TD> <TD>6</TD> <TD>6</TD> <TD>18</TD> <TD>6</TD> <TD>12</TD> <TD>12</TD> <TD>18</TD> <TD>12</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>What am I doing wrong ?</P> <P>&nbsp;</P> Thu, 09 Jan 2025 15:12:58 GMT https://community.qlik.com/t5/App-Development/Total-for-each-Date-in-pivot-table/m-p/2500643#M103179 kchamot 2025-01-09T15:12:58Z https://community.qlik.com/t5/App-Development/Total-for-each-Date-in-pivot-table/m-p/2500655#M103183 <P>Try&nbsp;<FONT face="courier new,courier"><SPAN>Sum(TOTAL &lt;Type&gt; Value)</SPAN></FONT></P> Thu, 09 Jan 2025 16:01:12 GMT https://community.qlik.com/t5/App-Development/Total-for-each-Date-in-pivot-table/m-p/2500655#M103183 henrikalmen 2025-01-09T16:01:12Z https://community.qlik.com/t5/App-Development/Total-for-each-Date-in-pivot-table/m-p/2500772#M103216 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/230254">@kchamot</a>&nbsp;I did below process:</P> <P>1. Inline Load</P> <P>ABC:<BR />load * Inline [<BR />Type,01.01.2025,02.01.2025<BR />A,1,2<BR />B,2,4<BR />C,3,6<BR />];</P> <P>Then in the front end, take a table chart and put below expression.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Bhushan_Mahajan_0-1736501688629.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/176351iB76F82D9655DAEEA/image-size/medium?v=v2&amp;px=400" role="button" title="Bhushan_Mahajan_0-1736501688629.png" alt="Bhushan_Mahajan_0-1736501688629.png" /></span></P> <P>&nbsp;</P> Fri, 10 Jan 2025 09:39:03 GMT https://community.qlik.com/t5/App-Development/Total-for-each-Date-in-pivot-table/m-p/2500772#M103216 Bhushan_Mahajan 2025-01-10T09:39:03Z