https://community.qlik.com/t5/App-Development/P-amp-L-Table-Total/m-p/1758530#M58599 <P>@Anonymous&nbsp; Create a inline table in script like below</P><LI-CODE lang="javascript">LOAD * inline [ Dim 1 2 ];</LI-CODE><P>&nbsp;</P><P>Now, in pivot table replace your Type Dimension with below</P><LI-CODE lang="javascript">=Pick(Dim,Type,'Total')</LI-CODE><P>&nbsp;</P> Wed, 04 Nov 2020 16:26:06 GMT Kushal_Chawda 2020-11-04T16:26:06Z https://community.qlik.com/t5/App-Development/P-amp-L-Table-Total/m-p/1758260#M58559 <P>how can i add a total row at the bottom of a P&amp;L pivot table, please help</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Control_Alt_Delete_2-1604436458193.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/43466iB4536B89FDA86BD6/image-size/medium?v=v2&amp;px=400" role="button" title="Control_Alt_Delete_2-1604436458193.png" alt="Control_Alt_Delete_2-1604436458193.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 03 Nov 2020 20:47:54 GMT https://community.qlik.com/t5/App-Development/P-amp-L-Table-Total/m-p/1758260#M58559 Anonymous 2020-11-03T20:47:54Z https://community.qlik.com/t5/App-Development/P-amp-L-Table-Total/m-p/1758530#M58599 <P>@Anonymous&nbsp; Create a inline table in script like below</P><LI-CODE lang="javascript">LOAD * inline [ Dim 1 2 ];</LI-CODE><P>&nbsp;</P><P>Now, in pivot table replace your Type Dimension with below</P><LI-CODE lang="javascript">=Pick(Dim,Type,'Total')</LI-CODE><P>&nbsp;</P> Wed, 04 Nov 2020 16:26:06 GMT https://community.qlik.com/t5/App-Development/P-amp-L-Table-Total/m-p/1758530#M58599 Kushal_Chawda 2020-11-04T16:26:06Z