https://community.qlik.com/t5/App-Development/aggregation-sum-by-field-in-pivot-table/m-p/1993343#M82473 <P>Manage to do it, Thanks</P> Mon, 17 Oct 2022 13:59:15 GMT Pestaninha 2022-10-17T13:59:15Z https://community.qlik.com/t5/App-Development/aggregation-sum-by-field-in-pivot-table/m-p/1993306#M82472 <P>Hi, I need to calculate the percentage of a subtotal(column Z) in a pivot table. Bellow&nbsp; is what I want to achieve:</P> <P>- Sum of the values</P> <P>- Percentage of the subtotals field 'Z'</P> <P>Is that possible? Thanks</P> <TABLE width="758"> <TBODY> <TR> <TD width="64">&nbsp;</TD> <TD width="55">&nbsp;</TD> <TD width="64">&nbsp;</TD> <TD width="159">&nbsp;</TD> <TD width="64">&nbsp;</TD> <TD width="64">&nbsp;</TD> <TD width="64">&nbsp;</TD> <TD width="96">Output expected</TD> <TD width="64">&nbsp;</TD> <TD width="64">&nbsp;</TD> </TR> <TR> <TD>X</TD> <TD>Y</TD> <TD>Z</TD> <TD>A</TD> <TD>Jan</TD> <TD>Feb</TD> <TD>Mar</TD> <TD>Jan</TD> <TD>Feb</TD> <TD>Mar</TD> </TR> <TR> <TD>B</TD> <TD>C</TD> <TD>1</TD> <TD>CH</TD> <TD>20</TD> <TD>10</TD> <TD>10</TD> <TD>40%</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>US</TD> <TD>30</TD> <TD>10</TD> <TD>5</TD> <TD>60%</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>2</TD> <TD>CH</TD> <TD>20</TD> <TD>-</TD> <TD>2</TD> <TD>91%</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>US</TD> <TD>2</TD> <TD>2</TD> <TD>2</TD> <TD>9%</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>D</TD> <TD>3</TD> <TD>CH</TD> <TD>0</TD> <TD>-</TD> <TD>-</TD> <TD>0</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>US</TD> <TD>10</TD> <TD>5</TD> <TD>5</TD> <TD>17%</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>CN</TD> <TD>20</TD> <TD>10</TD> <TD>10</TD> <TD>33%</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> <TD>AB</TD> <TD>30</TD> <TD>10</TD> <TD>10</TD> <TD>50%</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> </TBODY> </TABLE> Mon, 17 Oct 2022 13:00:27 GMT https://community.qlik.com/t5/App-Development/aggregation-sum-by-field-in-pivot-table/m-p/1993306#M82472 Pestaninha 2022-10-17T13:00:27Z https://community.qlik.com/t5/App-Development/aggregation-sum-by-field-in-pivot-table/m-p/1993343#M82473 <P>Manage to do it, Thanks</P> Mon, 17 Oct 2022 13:59:15 GMT https://community.qlik.com/t5/App-Development/aggregation-sum-by-field-in-pivot-table/m-p/1993343#M82473 Pestaninha 2022-10-17T13:59:15Z https://community.qlik.com/t5/App-Development/aggregation-sum-by-field-in-pivot-table/m-p/2012664#M83707 <P>What was the solution? I have the same problem..</P> Mon, 05 Dec 2022 12:04:01 GMT https://community.qlik.com/t5/App-Development/aggregation-sum-by-field-in-pivot-table/m-p/2012664#M83707 Femke_DPG 2022-12-05T12:04:01Z