topic Re: Percentage Of 2 Row in Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Percentage-Of-2-Row-in-Pivot-Table/m-p/1376220#M459488 <HTML><HEAD></HEAD><BODY><P>Like this</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177091_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 19 Sep 2017 15:47:50 GMT sunny_talwar 2017-09-19T15:47:50Z Percentage Of 2 Row in Pivot Table https://community.qlik.com/t5/QlikView/Percentage-Of-2-Row-in-Pivot-Table/m-p/1376219#M459487 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Would request help on how to calculate a % row based on 2 row in a pivot table.</P><P></P><P>I have unit numbers for each month for how many application received and from them how many got rejected for each product.</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177088_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>Now I have created a pivot in QV like below.</P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/177092_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P><P>But Now I would like to show the % of Application approved for each product. Application received / Application declined for each product each month.</P><P></P><P>Something like Below.</P><P><IMG class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/177093_pastedImage_2.png" style="max-height: 900px; max-width: 1200px;" /></P><P>Can I do that directly in the Pivot Table without adding any extra calculation in my table. Attached the QV for reference.</P><P></P><P>Thank you. </P></BODY></HTML> Tue, 19 Sep 2017 15:41:49 GMT https://community.qlik.com/t5/QlikView/Percentage-Of-2-Row-in-Pivot-Table/m-p/1376219#M459487 Anonymous 2017-09-19T15:41:49Z Re: Percentage Of 2 Row in Pivot Table https://community.qlik.com/t5/QlikView/Percentage-Of-2-Row-in-Pivot-Table/m-p/1376220#M459488 <HTML><HEAD></HEAD><BODY><P>Like this</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177091_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 19 Sep 2017 15:47:50 GMT https://community.qlik.com/t5/QlikView/Percentage-Of-2-Row-in-Pivot-Table/m-p/1376220#M459488 sunny_talwar 2017-09-19T15:47:50Z Re: Percentage Of 2 Row in Pivot Table https://community.qlik.com/t5/QlikView/Percentage-Of-2-Row-in-Pivot-Table/m-p/1376221#M459489 <HTML><HEAD></HEAD><BODY><P>Great... Thanks Sunny... Saved My Day&nbsp;&nbsp; </P></BODY></HTML> Wed, 20 Sep 2017 10:29:05 GMT https://community.qlik.com/t5/QlikView/Percentage-Of-2-Row-in-Pivot-Table/m-p/1376221#M459489 Anonymous 2017-09-20T10:29:05Z