https://community.qlik.com/t5/Management-Governance/summary-by-group/m-p/1596644#M14009 <P>Thank you for helping, but the results are still the same</P> Thu, 27 Jun 2019 09:00:12 GMT arie_rozzy 2019-06-27T09:00:12Z https://community.qlik.com/t5/Management-Governance/summary-by-group/m-p/1596598#M14007 <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Capture.JPG" style="width: 711px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/14518i5CB82FC6DAEC8279/image-size/large?v=v2&amp;px=999" role="button" title="Capture.JPG" alt="Capture.JPG" /></span></P><P>&nbsp;</P><P>my expression =&gt;&nbsp;Num(Sum(netamt)/Sum(Total netamt),'#,##0.0 %')</P><P>&nbsp;</P><P>what if I want the percentage of room type to be calculated per year??</P> Sat, 16 Nov 2024 05:27:59 GMT https://community.qlik.com/t5/Management-Governance/summary-by-group/m-p/1596598#M14007 arie_rozzy 2024-11-16T05:27:59Z https://community.qlik.com/t5/Management-Governance/summary-by-group/m-p/1596623#M14008 <P><SPAN>Num(Sum(netamt)/Sum(Total&lt;Year&gt; netamt),'#,##0.0 %')</SPAN></P> Thu, 27 Jun 2019 08:25:44 GMT https://community.qlik.com/t5/Management-Governance/summary-by-group/m-p/1596623#M14008 Channa 2019-06-27T08:25:44Z https://community.qlik.com/t5/Management-Governance/summary-by-group/m-p/1596644#M14009 <P>Thank you for helping, but the results are still the same</P> Thu, 27 Jun 2019 09:00:12 GMT https://community.qlik.com/t5/Management-Governance/summary-by-group/m-p/1596644#M14009 arie_rozzy 2019-06-27T09:00:12Z