topic Re: % Breakup functionality for more than one Dimensions in QlikView https://community.qlik.com/t5/QlikView/Breakup-functionality-for-more-than-one-Dimensions/m-p/657610#M240055 <HTML><HEAD></HEAD><BODY><P>Try this as expression: sum(Sales)/sum(<STRONG>TOTAL &lt;Region&gt;</STRONG> Sales). Use your real field names instead of the ones I used in the example.</P></BODY></HTML> Wed, 24 Sep 2014 11:50:58 GMT Gysbert_Wassenaar 2014-09-24T11:50:58Z % Breakup functionality for more than one Dimensions https://community.qlik.com/t5/QlikView/Breakup-functionality-for-more-than-one-Dimensions/m-p/657609#M240054 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Hello All,</SPAN></P><P></P><P>Consider the scenario as per the attached image where I want to show % Sales by Product/Region.</P><P>I am showing it in a Bar chart with two dimensions - Product Category and Country and one expression - sum(Sales Amount).</P><P>I want to see the <STRONG>% breakup of each Country as 100% and then the share of each Product Cat out of that 100% for each Country</STRONG>.</P><P>(Currently it breaks the 100% share for all the Countries and then for the Products for each country). The desired functionality is achieved only when one country is selected. But i would like to have this behavior when multiple countries are selected.</P><P></P><P>Let me know how this can be achieved in QlikView.</P><P></P><P>Thanks and Regards,</P><P>Diwakar</P></BODY></HTML> Mon, 22 Sep 2014 07:13:33 GMT https://community.qlik.com/t5/QlikView/Breakup-functionality-for-more-than-one-Dimensions/m-p/657609#M240054 diwakarnahata 2014-09-22T07:13:33Z Re: % Breakup functionality for more than one Dimensions https://community.qlik.com/t5/QlikView/Breakup-functionality-for-more-than-one-Dimensions/m-p/657610#M240055 <HTML><HEAD></HEAD><BODY><P>Try this as expression: sum(Sales)/sum(<STRONG>TOTAL &lt;Region&gt;</STRONG> Sales). Use your real field names instead of the ones I used in the example.</P></BODY></HTML> Wed, 24 Sep 2014 11:50:58 GMT https://community.qlik.com/t5/QlikView/Breakup-functionality-for-more-than-one-Dimensions/m-p/657610#M240055 Gysbert_Wassenaar 2014-09-24T11:50:58Z