topic Re: How to calculate Market Share using the below data in Pivot table in Qlik Sense in App Development https://community.qlik.com/t5/App-Development/How-to-calculate-Market-Share-using-the-below-data-in-Pivot/m-p/1513075#M36548 <P>Try this</P><PRE>Sum(Volume)/Sum(TOTAL &lt;Territory, Month&gt; Volume)</PRE><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 984px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/1107i059785F722A2EF04/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P> Tue, 27 Nov 2018 17:21:00 GMT sunny_talwar 2018-11-27T17:21:00Z How to calculate Market Share using the below data in Pivot table in Qlik Sense https://community.qlik.com/t5/App-Development/How-to-calculate-Market-Share-using-the-below-data-in-Pivot/m-p/1513069#M36547 <TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Territory</TD><TD>Product</TD><TD>Month</TD><TD>Volume</TD></TR><TR><TD>T_1</TD><TD>P1</TD><TD>Jan</TD><TD>10</TD></TR><TR><TD>T_1</TD><TD>P2</TD><TD>Jan</TD><TD>20</TD></TR><TR><TD>T_1</TD><TD>P3</TD><TD>Jan</TD><TD>30</TD></TR><TR><TD>T_1</TD><TD>P4</TD><TD>Jan</TD><TD>40</TD></TR><TR><TD>T_1</TD><TD>P1</TD><TD>Feb</TD><TD>25</TD></TR><TR><TD>T_1</TD><TD>P2</TD><TD>Feb</TD><TD>35</TD></TR><TR><TD>T_1</TD><TD>P3</TD><TD>Feb</TD><TD>45</TD></TR><TR><TD>T_1</TD><TD>P4</TD><TD>Feb</TD><TD>55</TD></TR><TR><TD>T_1</TD><TD>P1</TD><TD>Mar</TD><TD>15</TD></TR><TR><TD>T_1</TD><TD>P2</TD><TD>Mar</TD><TD>20</TD></TR><TR><TD>T_1</TD><TD>P3</TD><TD>Mar</TD><TD>25</TD></TR><TR><TD>T_1</TD><TD>P4</TD><TD>Mar</TD><TD>35</TD></TR><TR><TD>T_1</TD><TD>P1</TD><TD>Apr</TD><TD>30</TD></TR><TR><TD>T_1</TD><TD>P2</TD><TD>Apr</TD><TD>40</TD></TR><TR><TD>T_1</TD><TD>P3</TD><TD>Apr</TD><TD>50</TD></TR><TR><TD>T_1</TD><TD>P4</TD><TD>Apr</TD><TD>60</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I am Trying to calculate the Market Share at territory level. The Answer what I am expecting will be in following format.&nbsp;</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Territory</TD><TD>Product</TD><TD>Jan</TD><TD>Feb</TD><TD>Mar</TD><TD>Apr</TD></TR><TR><TD>T_1</TD><TD>P1</TD><TD>10%</TD><TD>16%</TD><TD>16%</TD><TD>17%</TD></TR><TR><TD>&nbsp;</TD><TD>P2</TD><TD>20%</TD><TD>22%</TD><TD>21%</TD><TD>22%</TD></TR><TR><TD>&nbsp;</TD><TD>P3</TD><TD>30%</TD><TD>28%</TD><TD>26%</TD><TD>28%</TD></TR><TR><TD>&nbsp;</TD><TD>P4</TD><TD>40%</TD><TD>34%</TD><TD>37%</TD><TD>33%</TD></TR><TR><TD>T_2</TD><TD>P1</TD><TD>10%</TD><TD>16%</TD><TD>16%</TD><TD>17%</TD></TR><TR><TD>&nbsp;</TD><TD>P2</TD><TD>20%</TD><TD>22%</TD><TD>21%</TD><TD>22%</TD></TR><TR><TD>&nbsp;</TD><TD>P3</TD><TD>30%</TD><TD>28%</TD><TD>26%</TD><TD>28%</TD></TR><TR><TD>&nbsp;</TD><TD>P4</TD><TD>40%</TD><TD>34%</TD><TD>37%</TD><TD>33%</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I tried using multiple functions in the expression in Qlik Sense but I am not getting the correct values. Any help&nbsp; is appreciated.</P> Sat, 16 Nov 2024 21:49:25 GMT https://community.qlik.com/t5/App-Development/How-to-calculate-Market-Share-using-the-below-data-in-Pivot/m-p/1513069#M36547 Anonymous 2024-11-16T21:49:25Z Re: How to calculate Market Share using the below data in Pivot table in Qlik Sense https://community.qlik.com/t5/App-Development/How-to-calculate-Market-Share-using-the-below-data-in-Pivot/m-p/1513075#M36548 <P>Try this</P><PRE>Sum(Volume)/Sum(TOTAL &lt;Territory, Month&gt; Volume)</PRE><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 984px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/1107i059785F722A2EF04/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P> Tue, 27 Nov 2018 17:21:00 GMT https://community.qlik.com/t5/App-Development/How-to-calculate-Market-Share-using-the-below-data-in-Pivot/m-p/1513075#M36548 sunny_talwar 2018-11-27T17:21:00Z