topic pivot table - calculate share correctly in QlikView https://community.qlik.com/t5/QlikView/pivot-table-calculate-share-correctly/m-p/468027#M488760 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P>i have a pivot table with 2 dimension - Year &amp; salesman and i want to see share of sales (year by year) between the salesmen; the problem is when i sellect just a salesman, or less than all of them because share becomes 100%; if i put {1} in formula is not ok because it calculates and solves share for each salesman even i select just one of them but is wrong when i want these situation not for all product and i select just one, or two </P><P>also, in reality i have a cyclic Year/Month and i want a formula ok for both situation</P><P>i attached the document</P><P></P><P>Thanks,</P><P>Cosmin</P></BODY></HTML> Mon, 26 Nov 2012 22:27:23 GMT 2012-11-26T22:27:23Z pivot table - calculate share correctly https://community.qlik.com/t5/QlikView/pivot-table-calculate-share-correctly/m-p/468027#M488760 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P>i have a pivot table with 2 dimension - Year &amp; salesman and i want to see share of sales (year by year) between the salesmen; the problem is when i sellect just a salesman, or less than all of them because share becomes 100%; if i put {1} in formula is not ok because it calculates and solves share for each salesman even i select just one of them but is wrong when i want these situation not for all product and i select just one, or two </P><P>also, in reality i have a cyclic Year/Month and i want a formula ok for both situation</P><P>i attached the document</P><P></P><P>Thanks,</P><P>Cosmin</P></BODY></HTML> Mon, 26 Nov 2012 22:27:23 GMT https://community.qlik.com/t5/QlikView/pivot-table-calculate-share-correctly/m-p/468027#M488760 2012-11-26T22:27:23Z Re: pivot table - calculate share correctly https://community.qlik.com/t5/QlikView/pivot-table-calculate-share-correctly/m-p/468028#M488761 <HTML><HEAD></HEAD><BODY><P>Cosmin,</P><P></P><P>Try putting your {1} or {&lt;salesman&gt;} ignore set in the denominator only.</P><P></P><P>Regards,</P><P>Vlad</P></BODY></HTML> Tue, 27 Nov 2012 04:19:15 GMT https://community.qlik.com/t5/QlikView/pivot-table-calculate-share-correctly/m-p/468028#M488761 vgutkovsky 2012-11-27T04:19:15Z Re: pivot table - calculate share correctly https://community.qlik.com/t5/QlikView/pivot-table-calculate-share-correctly/m-p/468029#M488762 <HTML><HEAD></HEAD><BODY><P>it's ok now; i used&nbsp; Sum({&lt;salesman&gt;}.....</P><P>many thanks</P></BODY></HTML> Tue, 27 Nov 2012 14:25:44 GMT https://community.qlik.com/t5/QlikView/pivot-table-calculate-share-correctly/m-p/468029#M488762 2012-11-27T14:25:44Z