topic Re: How to compute Share to sub category using pivot in App Development https://community.qlik.com/t5/App-Development/How-to-compute-Share-to-sub-category-using-pivot/m-p/2428218#M96342 <P>Thanks got it! I forgot that it should be with like this &lt;&gt;&nbsp;</P> Thu, 07 Mar 2024 11:04:05 GMT bryan_21 2024-03-07T11:04:05Z How to compute Share to sub category using pivot https://community.qlik.com/t5/App-Development/How-to-compute-Share-to-sub-category-using-pivot/m-p/2428147#M96335 <P>How to achieve computation using pivot table. Compute Share to Product Total using set analysis?</P> <P>Sample like this:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="bryan_21_0-1709803232089.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/161501i95AE33B88DD388BD/image-size/medium?v=v2&amp;px=400" role="button" title="bryan_21_0-1709803232089.png" alt="bryan_21_0-1709803232089.png" /></span></P> <P>&nbsp;</P> Thu, 07 Mar 2024 09:37:10 GMT https://community.qlik.com/t5/App-Development/How-to-compute-Share-to-sub-category-using-pivot/m-p/2428147#M96335 bryan_21 2024-03-07T09:37:10Z Re: How to compute Share to sub category using pivot https://community.qlik.com/t5/App-Development/How-to-compute-Share-to-sub-category-using-pivot/m-p/2428184#M96339 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="LRuCelver_0-1709807448165.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/161503iF3F88597AA473EAA/image-size/medium?v=v2&amp;px=400" role="button" title="LRuCelver_0-1709807448165.png" alt="LRuCelver_0-1709807448165.png" /></span></P> <LI-CODE lang="markup">Data: NoConcatenate Load * Inline [ ProductGroup, Product, Sold A, A1, 2 B, B1, 1 B, B2, 3 C, C1, 2 C, C2, 4 ];</LI-CODE> Thu, 07 Mar 2024 10:31:33 GMT https://community.qlik.com/t5/App-Development/How-to-compute-Share-to-sub-category-using-pivot/m-p/2428184#M96339 LRuCelver 2024-03-07T10:31:33Z Re: How to compute Share to sub category using pivot https://community.qlik.com/t5/App-Development/How-to-compute-Share-to-sub-category-using-pivot/m-p/2428218#M96342 <P>Thanks got it! I forgot that it should be with like this &lt;&gt;&nbsp;</P> Thu, 07 Mar 2024 11:04:05 GMT https://community.qlik.com/t5/App-Development/How-to-compute-Share-to-sub-category-using-pivot/m-p/2428218#M96342 bryan_21 2024-03-07T11:04:05Z