topic % in Pivot Table in QlikView https://community.qlik.com/t5/QlikView/in-Pivot-Table/m-p/161802#M589643 <HTML><HEAD></HEAD><BODY><P>If I understood your question correctly, this should work (where 1 is the ID of the field that you are dividing by):</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Sum (value)/FieldValue('value',FieldIndex('ID',1))</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Sat, 27 Feb 2010 00:41:34 GMT vgutkovsky 2010-02-27T00:41:34Z % in Pivot Table https://community.qlik.com/t5/QlikView/in-Pivot-Table/m-p/161801#M589642 <HTML><HEAD></HEAD><BODY><P>Hi!, I´m trying to calculate the percentile value of an variable (expense) in function of another variable (revenues) in one same dimension (count).</P><P>I have tried many different ways to solve problem, without sucess</P><P>If possible to make the percentage in function of the ID (ID=1, 500)</P><P></P><P>ID count value change% (objective)</P><P>1 revenues 500 =500/<B>500</B></P><P>2 expenses 50 =50/<B>500</B></P></BODY></HTML> Fri, 26 Feb 2010 20:26:37 GMT https://community.qlik.com/t5/QlikView/in-Pivot-Table/m-p/161801#M589642 2010-02-26T20:26:37Z % in Pivot Table https://community.qlik.com/t5/QlikView/in-Pivot-Table/m-p/161802#M589643 <HTML><HEAD></HEAD><BODY><P>If I understood your question correctly, this should work (where 1 is the ID of the field that you are dividing by):</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Sum (value)/FieldValue('value',FieldIndex('ID',1))</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Sat, 27 Feb 2010 00:41:34 GMT https://community.qlik.com/t5/QlikView/in-Pivot-Table/m-p/161802#M589643 vgutkovsky 2010-02-27T00:41:34Z