https://community.qlik.com/t5/QlikView/QlikView-Pivot-table-to-calculate-percentage-by-row/m-p/1915987#M1218344 <P>Hi Experts,</P> <P>I am experiencing a scenario where pivot table shows correct set of percentage values as shown in Screenshot (1) when I try to explore the placement ratio % of&nbsp; (Days / Total) for an individual company. However, when I try to bring more companies into this table (Example: Top 3 companies), placement ratio percentage is getting calculated as "Day / Overall Total of submissions" as shown in Screenshot (2).&nbsp;</P> <P>I need placement ratio % to be calculated by row for each companies. Is this possible to implement here?</P> <P><U><STRONG>Screenshot (1):</STRONG></U></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vijaymadhavan28_0-1649351856025.png" style="width: 618px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/76615i0076D68231803D34/image-dimensions/618x95?v=v2" width="618" height="95" role="button" title="vijaymadhavan28_0-1649351856025.png" alt="vijaymadhavan28_0-1649351856025.png" /></span></P> <P>Screenshot (2):</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vijaymadhavan28_2-1649352081969.png" style="width: 643px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/76617i97786F630C8A5B75/image-dimensions/643x189?v=v2" width="643" height="189" role="button" title="vijaymadhavan28_2-1649352081969.png" alt="vijaymadhavan28_2-1649352081969.png" /></span></P> <P>Looking forward for your comments.</P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 07 Apr 2022 17:27:43 GMT vijaymadhavan28 2022-04-07T17:27:43Z https://community.qlik.com/t5/QlikView/QlikView-Pivot-table-to-calculate-percentage-by-row/m-p/1915987#M1218344 <P>Hi Experts,</P> <P>I am experiencing a scenario where pivot table shows correct set of percentage values as shown in Screenshot (1) when I try to explore the placement ratio % of&nbsp; (Days / Total) for an individual company. However, when I try to bring more companies into this table (Example: Top 3 companies), placement ratio percentage is getting calculated as "Day / Overall Total of submissions" as shown in Screenshot (2).&nbsp;</P> <P>I need placement ratio % to be calculated by row for each companies. Is this possible to implement here?</P> <P><U><STRONG>Screenshot (1):</STRONG></U></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vijaymadhavan28_0-1649351856025.png" style="width: 618px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/76615i0076D68231803D34/image-dimensions/618x95?v=v2" width="618" height="95" role="button" title="vijaymadhavan28_0-1649351856025.png" alt="vijaymadhavan28_0-1649351856025.png" /></span></P> <P>Screenshot (2):</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vijaymadhavan28_2-1649352081969.png" style="width: 643px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/76617i97786F630C8A5B75/image-dimensions/643x189?v=v2" width="643" height="189" role="button" title="vijaymadhavan28_2-1649352081969.png" alt="vijaymadhavan28_2-1649352081969.png" /></span></P> <P>Looking forward for your comments.</P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 07 Apr 2022 17:27:43 GMT https://community.qlik.com/t5/QlikView/QlikView-Pivot-table-to-calculate-percentage-by-row/m-p/1915987#M1218344 vijaymadhavan28 2022-04-07T17:27:43Z https://community.qlik.com/t5/QlikView/QlikView-Pivot-table-to-calculate-percentage-by-row/m-p/1916222#M1218350 <P>Hi</P> <P>Hope this helps</P> <P>For individual company, you need to use Total&lt;Company&gt; in ur expression instead of Total alone.&nbsp;</P> <P>Ex: Count(days) / Count(Total&lt;Company&gt; days)</P> Fri, 08 Apr 2022 10:05:58 GMT https://community.qlik.com/t5/QlikView/QlikView-Pivot-table-to-calculate-percentage-by-row/m-p/1916222#M1218350 MayilVahanan 2022-04-08T10:05:58Z