https://community.qlik.com/t5/App-Development/How-to-represent-in-a-pivot-table/m-p/2134763#M92216 <P>Hi,</P> <P>Please help me how can below represention be achieved in a pivot table. Need to represent the Customer Count for two periods so that the movement of count between periods in Customer Category can be shown.</P> <P>&nbsp;</P> <TABLE width="681"> <TBODY> <TR> <TD width="63.9875px">&nbsp;</TD> <TD width="168.637px">&nbsp;</TD> <TD colspan="7" width="447.575px">Period 2 ----&gt;</TD> </TR> <TR> <TD rowspan="8" width="63.9875px">Period1</TD> <TD width="168.637px"> <P data-ccp-timestamp="1699242097822">Customer Catgory</P> </TD> <TD width="63.9px">A</TD> <TD width="63.925px">B</TD> <TD width="63.925px">C</TD> <TD width="63.925px">D</TD> <TD width="63.925px">E</TD> <TD width="63.9625px">F</TD> <TD width="64.0125px">Total</TD> </TR> <TR> <TD width="168.637px">A</TD> <TD width="63.9px">279</TD> <TD width="63.925px">-</TD> <TD width="63.925px">-</TD> <TD width="63.925px">-</TD> <TD width="63.925px">-</TD> <TD width="63.9625px">-</TD> <TD width="64.0125px"><STRONG>279</STRONG></TD> </TR> <TR> <TD width="168.637px">B</TD> <TD width="63.9px">23</TD> <TD width="63.925px">1,339</TD> <TD width="63.925px">-</TD> <TD width="63.925px">-</TD> <TD width="63.925px">-</TD> <TD width="63.9625px">-</TD> <TD width="64.0125px"><STRONG>1,362</STRONG></TD> </TR> <TR> <TD width="168.637px">C</TD> <TD width="63.9px">-</TD> <TD width="63.925px">182</TD> <TD width="63.925px">2,567</TD> <TD width="63.925px">-</TD> <TD width="63.925px">-</TD> <TD width="63.9625px">-</TD> <TD width="64.0125px"><STRONG>2,749</STRONG></TD> </TR> <TR> <TD width="168.637px">D</TD> <TD width="63.9px">-</TD> <TD width="63.925px">5</TD> <TD width="63.925px">528</TD> <TD width="63.925px">5,617</TD> <TD width="63.925px">-</TD> <TD width="63.9625px">-</TD> <TD width="64.0125px"><STRONG>6,150</STRONG></TD> </TR> <TR> <TD width="168.637px">E</TD> <TD width="63.9px">-</TD> <TD width="63.925px">1</TD> <TD width="63.925px">13</TD> <TD width="63.925px">1,365</TD> <TD width="63.925px">3,978</TD> <TD width="63.9625px">-</TD> <TD width="64.0125px"><STRONG>5,357</STRONG></TD> </TR> <TR> <TD width="168.637px">F</TD> <TD width="63.9px">-</TD> <TD width="63.925px">-</TD> <TD width="63.925px">4</TD> <TD width="63.925px">205</TD> <TD width="63.925px">2,429</TD> <TD width="63.9625px">13,459</TD> <TD width="64.0125px"><STRONG>16,097</STRONG></TD> </TR> <TR> <TD width="168.637px">Total</TD> <TD width="63.9px"><STRONG>302</STRONG></TD> <TD width="63.925px"><STRONG>1,527</STRONG></TD> <TD width="63.925px"><STRONG>3,112</STRONG></TD> <TD width="63.925px"><STRONG>7,187</STRONG></TD> <TD width="63.925px"><STRONG>6,407</STRONG></TD> <TD width="63.9625px"><STRONG>13,459</STRONG></TD> <TD width="64.0125px"><STRONG>31,994</STRONG></TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Regards,</P> <P>Suhas</P> Mon, 06 Nov 2023 03:49:56 GMT suhasarchak 2023-11-06T03:49:56Z https://community.qlik.com/t5/App-Development/How-to-represent-in-a-pivot-table/m-p/2134763#M92216 <P>Hi,</P> <P>Please help me how can below represention be achieved in a pivot table. Need to represent the Customer Count for two periods so that the movement of count between periods in Customer Category can be shown.</P> <P>&nbsp;</P> <TABLE width="681"> <TBODY> <TR> <TD width="63.9875px">&nbsp;</TD> <TD width="168.637px">&nbsp;</TD> <TD colspan="7" width="447.575px">Period 2 ----&gt;</TD> </TR> <TR> <TD rowspan="8" width="63.9875px">Period1</TD> <TD width="168.637px"> <P data-ccp-timestamp="1699242097822">Customer Catgory</P> </TD> <TD width="63.9px">A</TD> <TD width="63.925px">B</TD> <TD width="63.925px">C</TD> <TD width="63.925px">D</TD> <TD width="63.925px">E</TD> <TD width="63.9625px">F</TD> <TD width="64.0125px">Total</TD> </TR> <TR> <TD width="168.637px">A</TD> <TD width="63.9px">279</TD> <TD width="63.925px">-</TD> <TD width="63.925px">-</TD> <TD width="63.925px">-</TD> <TD width="63.925px">-</TD> <TD width="63.9625px">-</TD> <TD width="64.0125px"><STRONG>279</STRONG></TD> </TR> <TR> <TD width="168.637px">B</TD> <TD width="63.9px">23</TD> <TD width="63.925px">1,339</TD> <TD width="63.925px">-</TD> <TD width="63.925px">-</TD> <TD width="63.925px">-</TD> <TD width="63.9625px">-</TD> <TD width="64.0125px"><STRONG>1,362</STRONG></TD> </TR> <TR> <TD width="168.637px">C</TD> <TD width="63.9px">-</TD> <TD width="63.925px">182</TD> <TD width="63.925px">2,567</TD> <TD width="63.925px">-</TD> <TD width="63.925px">-</TD> <TD width="63.9625px">-</TD> <TD width="64.0125px"><STRONG>2,749</STRONG></TD> </TR> <TR> <TD width="168.637px">D</TD> <TD width="63.9px">-</TD> <TD width="63.925px">5</TD> <TD width="63.925px">528</TD> <TD width="63.925px">5,617</TD> <TD width="63.925px">-</TD> <TD width="63.9625px">-</TD> <TD width="64.0125px"><STRONG>6,150</STRONG></TD> </TR> <TR> <TD width="168.637px">E</TD> <TD width="63.9px">-</TD> <TD width="63.925px">1</TD> <TD width="63.925px">13</TD> <TD width="63.925px">1,365</TD> <TD width="63.925px">3,978</TD> <TD width="63.9625px">-</TD> <TD width="64.0125px"><STRONG>5,357</STRONG></TD> </TR> <TR> <TD width="168.637px">F</TD> <TD width="63.9px">-</TD> <TD width="63.925px">-</TD> <TD width="63.925px">4</TD> <TD width="63.925px">205</TD> <TD width="63.925px">2,429</TD> <TD width="63.9625px">13,459</TD> <TD width="64.0125px"><STRONG>16,097</STRONG></TD> </TR> <TR> <TD width="168.637px">Total</TD> <TD width="63.9px"><STRONG>302</STRONG></TD> <TD width="63.925px"><STRONG>1,527</STRONG></TD> <TD width="63.925px"><STRONG>3,112</STRONG></TD> <TD width="63.925px"><STRONG>7,187</STRONG></TD> <TD width="63.925px"><STRONG>6,407</STRONG></TD> <TD width="63.9625px"><STRONG>13,459</STRONG></TD> <TD width="64.0125px"><STRONG>31,994</STRONG></TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Regards,</P> <P>Suhas</P> Mon, 06 Nov 2023 03:49:56 GMT https://community.qlik.com/t5/App-Development/How-to-represent-in-a-pivot-table/m-p/2134763#M92216 suhasarchak 2023-11-06T03:49:56Z