https://community.qlik.com/t5/QlikView/Calculation-expression-in-a-Text-Object/m-p/1647132#M730403 <P>=Sum({&lt;category={'Shirt'}&gt;} Profit)/sum( total Profit)*100&amp;'%'</P> Thu, 14 Nov 2019 16:41:01 GMT manoranjan_d 2019-11-14T16:41:01Z https://community.qlik.com/t5/QlikView/Calculation-expression-in-a-Text-Object/m-p/1647003#M730398 <P>Can somebody please help me to get the expression in a text object to calculate the share of profit contributed by Shirt category in %.</P><TABLE border="1"><TBODY><TR><TD><STRONG>category</STRONG></TD><TD><STRONG>Profit</STRONG></TD></TR><TR><TD>Shoe</TD><TD>500</TD></TR><TR><TD>Tablets</TD><TD>3000</TD></TR><TR><TD>Mobile</TD><TD>500</TD></TR><TR><TD>Shirt</TD><TD>1000</TD></TR></TBODY></TABLE> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Calculation-expression-in-a-Text-Object/m-p/1647003#M730398 sk88024 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Calculation-expression-in-a-Text-Object/m-p/1647007#M730399 <P><STRONG>Sum(Profit)/Sum({&lt;Category={'Shirt'}&gt;} Profit)</STRONG></P> Thu, 14 Nov 2019 14:01:07 GMT https://community.qlik.com/t5/QlikView/Calculation-expression-in-a-Text-Object/m-p/1647007#M730399 Anil_Babu_Samineni 2019-11-14T14:01:07Z https://community.qlik.com/t5/QlikView/Calculation-expression-in-a-Text-Object/m-p/1647070#M730400 <P>It worked with a little modification.</P><P>=Sum({&lt;Category={'Shirt'}&gt;} Profit)/Sum(Profit)*100 &amp; '%'</P><P>Thank You!</P> Thu, 14 Nov 2019 15:09:25 GMT https://community.qlik.com/t5/QlikView/Calculation-expression-in-a-Text-Object/m-p/1647070#M730400 sk88024 2019-11-14T15:09:25Z https://community.qlik.com/t5/QlikView/Calculation-expression-in-a-Text-Object/m-p/1647132#M730403 <P>=Sum({&lt;category={'Shirt'}&gt;} Profit)/sum( total Profit)*100&amp;'%'</P> Thu, 14 Nov 2019 16:41:01 GMT https://community.qlik.com/t5/QlikView/Calculation-expression-in-a-Text-Object/m-p/1647132#M730403 manoranjan_d 2019-11-14T16:41:01Z