https://community.qlik.com/t5/App-Development/QLik-sense-Pivot-table-custom-column/m-p/1808516#M65850 <P>Hi All,</P><P>I do have sales data. I need to create Pivot table with total as last column. The categories are dynamic, sometime we might have less or more not static. Im unable to do it.</P><P>INput data:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="arun1_3-1621281552930.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/55142iDEC035E03EC052E7/image-size/medium?v=v2&amp;px=400" role="button" title="arun1_3-1621281552930.png" alt="arun1_3-1621281552930.png" /></span></P><P>&nbsp;</P><P>Expected Output:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="arun1_4-1621281581464.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/55143i982971FEF2D6642D/image-size/medium?v=v2&amp;px=400" role="button" title="arun1_4-1621281581464.png" alt="arun1_4-1621281581464.png" /></span></P><P>&nbsp;</P><P>totals category is sum of sale1+sale2. Your help is greatly appreciated.</P> Mon, 17 May 2021 20:02:23 GMT arun1 2021-05-17T20:02:23Z https://community.qlik.com/t5/App-Development/QLik-sense-Pivot-table-custom-column/m-p/1808516#M65850 <P>Hi All,</P><P>I do have sales data. I need to create Pivot table with total as last column. The categories are dynamic, sometime we might have less or more not static. Im unable to do it.</P><P>INput data:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="arun1_3-1621281552930.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/55142iDEC035E03EC052E7/image-size/medium?v=v2&amp;px=400" role="button" title="arun1_3-1621281552930.png" alt="arun1_3-1621281552930.png" /></span></P><P>&nbsp;</P><P>Expected Output:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="arun1_4-1621281581464.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/55143i982971FEF2D6642D/image-size/medium?v=v2&amp;px=400" role="button" title="arun1_4-1621281581464.png" alt="arun1_4-1621281581464.png" /></span></P><P>&nbsp;</P><P>totals category is sum of sale1+sale2. Your help is greatly appreciated.</P> Mon, 17 May 2021 20:02:23 GMT https://community.qlik.com/t5/App-Development/QLik-sense-Pivot-table-custom-column/m-p/1808516#M65850 arun1 2021-05-17T20:02:23Z