https://community.qlik.com/t5/App-Development/Finding-of-Total/m-p/1726365#M55367 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/119802">@AshwathRaj_26</a>&nbsp;</P><P>Maye be :</P><LI-CODE lang="python">sum(Sales)/sum(total&lt;Region&gt; Sales)</LI-CODE><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 583px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/37187i332732DA5B9DC568/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P> Thu, 09 Jul 2020 08:09:14 GMT Taoufiq_Zarra 2020-07-09T08:09:14Z https://community.qlik.com/t5/App-Development/Finding-of-Total/m-p/1726330#M55365 <P>Please have a look at the attached image.&nbsp;</P><P>&nbsp;</P><P>I am using a table</P><P>&nbsp;</P><P>I want to calculate the % of total sales of each category restarting every region&nbsp;</P><P>E.g</P><P>Region&nbsp; &nbsp; Product&nbsp; &nbsp; Sales&nbsp; &nbsp; &nbsp;Expected % of Total</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 16%&nbsp;&nbsp;</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 33%</P><P>&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50%</P><P>-----------------------------------------------</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15%&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;16&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20%</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;64%</P><P>&nbsp;</P><P>Currently the total sales is calculated for all regions and all categories</P><P>&nbsp;</P><P>How to resolve this&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 01:56:48 GMT https://community.qlik.com/t5/App-Development/Finding-of-Total/m-p/1726330#M55365 AshwathRaj_26 2024-11-16T01:56:48Z https://community.qlik.com/t5/App-Development/Finding-of-Total/m-p/1726365#M55367 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/119802">@AshwathRaj_26</a>&nbsp;</P><P>Maye be :</P><LI-CODE lang="python">sum(Sales)/sum(total&lt;Region&gt; Sales)</LI-CODE><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 583px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/37187i332732DA5B9DC568/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P> Thu, 09 Jul 2020 08:09:14 GMT https://community.qlik.com/t5/App-Development/Finding-of-Total/m-p/1726365#M55367 Taoufiq_Zarra 2020-07-09T08:09:14Z