topic Re: Pivot and Percentage in QlikView https://community.qlik.com/t5/QlikView/Pivot-and-Percentage/m-p/1122428#M369825 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>Sum(Measure)/Sum(TOTAL Measure)</STRONG></P></BODY></HTML> Wed, 17 Aug 2016 11:33:47 GMT sunny_talwar 2016-08-17T11:33:47Z Pivot and Percentage https://community.qlik.com/t5/QlikView/Pivot-and-Percentage/m-p/1122426#M369823 <HTML><HEAD></HEAD><BODY><P>&nbsp;&nbsp;&nbsp; Ho to achieve this in Pivot Table with Aggr Function ? </P><P></P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG> Customer</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Jan</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Jan %</TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;"><P>50</P></TD><TD style="padding: 2px;">50%</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">10%</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">20 %</TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">20 %</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">100 %</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 17 Aug 2016 08:31:44 GMT https://community.qlik.com/t5/QlikView/Pivot-and-Percentage/m-p/1122426#M369823 navaskhan 2016-08-17T08:31:44Z Re: Pivot and Percentage https://community.qlik.com/t5/QlikView/Pivot-and-Percentage/m-p/1122427#M369824 <HTML><HEAD></HEAD><BODY><P>=column(2)/100&nbsp;&nbsp; and&nbsp; tick on Show in %</P></BODY></HTML> Wed, 17 Aug 2016 11:31:59 GMT https://community.qlik.com/t5/QlikView/Pivot-and-Percentage/m-p/1122427#M369824 vikasmahajan 2016-08-17T11:31:59Z Re: Pivot and Percentage https://community.qlik.com/t5/QlikView/Pivot-and-Percentage/m-p/1122428#M369825 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>Sum(Measure)/Sum(TOTAL Measure)</STRONG></P></BODY></HTML> Wed, 17 Aug 2016 11:33:47 GMT https://community.qlik.com/t5/QlikView/Pivot-and-Percentage/m-p/1122428#M369825 sunny_talwar 2016-08-17T11:33:47Z Re: Pivot and Percentage https://community.qlik.com/t5/QlikView/Pivot-and-Percentage/m-p/1122429#M369826 <HTML><HEAD></HEAD><BODY><P>This is not working in case of Multiple Months. Because Total will take the Jan &amp; Feb Total.</P></BODY></HTML> Wed, 17 Aug 2016 11:47:17 GMT https://community.qlik.com/t5/QlikView/Pivot-and-Percentage/m-p/1122429#M369826 navaskhan 2016-08-17T11:47:17Z Re: Pivot and Percentage https://community.qlik.com/t5/QlikView/Pivot-and-Percentage/m-p/1122430#M369827 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Sum(Measure)/Sum(TOTAL &lt;<SPAN style="color: #ff0000;">Customer</SPAN>&gt; Measure)</STRONG></P><P></P><P>or</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Sum(Measure)/Sum(TOTAL &lt;<SPAN style="color: #ff0000;">Month</SPAN>&gt; Measure)</STRONG></P></BODY></HTML> Wed, 17 Aug 2016 12:37:59 GMT https://community.qlik.com/t5/QlikView/Pivot-and-Percentage/m-p/1122430#M369827 sunny_talwar 2016-08-17T12:37:59Z