topic Re: Pivot table with two dimensions, calculation question in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-with-two-dimensions-calculation-question/m-p/357644#M132699 <HTML><HEAD></HEAD><BODY><P>Thank you, that's exactly what I needed.</P></BODY></HTML> Mon, 18 Jun 2012 15:38:05 GMT 2012-06-18T15:38:05Z Pivot table with two dimensions, calculation question https://community.qlik.com/t5/QlikView/Pivot-table-with-two-dimensions-calculation-question/m-p/357642#M132697 <HTML><HEAD></HEAD><BODY><P>Hi all -</P><P></P><P>I have a question that I haven't been able to find the answer for here in the community.&nbsp; I have a pivot table with two dimensions, business unit and employee.&nbsp; I would like to add a calculation that shows the percentage of business unit (BU) sales that the employee makes up.&nbsp; </P><P></P><P>For example:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>BU</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Employee</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Sales</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>% of Sales</STRONG></SPAN></TH></TR><TR><TD>A</TD><TD></TD><TD>1000.00</TD><TD>100%</TD></TR><TR><TD></TD><TD>John Doe</TD><TD>750.00</TD><TD>75%</TD></TR><TR><TD></TD><TD>Jane Smith</TD><TD>250.00</TD><TD>25%</TD></TR><TR><TD>B</TD><TD></TD><TD>5000.00</TD><TD>100%</TD></TR><TR><TD></TD><TD>James Jones</TD><TD>1000.00</TD><TD>20%</TD></TR><TR><TD></TD><TD>Greg Smith</TD><TD>3000.00</TD><TD>60%</TD></TR><TR><TD></TD><TD>Jane Johnson</TD><TD>1000.00</TD><TD>20%</TD></TR></TBODY></TABLE><P></P><P></P><P>Is this possible?&nbsp; I can only seem to get the % of the overall total not the BU total.</P><P></P><P>Thanks in advance for any help!</P><P>Leigh</P></BODY></HTML> Mon, 18 Jun 2012 15:02:44 GMT https://community.qlik.com/t5/QlikView/Pivot-table-with-two-dimensions-calculation-question/m-p/357642#M132697 2012-06-18T15:02:44Z Re: Pivot table with two dimensions, calculation question https://community.qlik.com/t5/QlikView/Pivot-table-with-two-dimensions-calculation-question/m-p/357643#M132698 <HTML><HEAD></HEAD><BODY><P>Please, see the attached file and let me know if you have some questions.</P></BODY></HTML> Mon, 18 Jun 2012 15:27:53 GMT https://community.qlik.com/t5/QlikView/Pivot-table-with-two-dimensions-calculation-question/m-p/357643#M132698 2012-06-18T15:27:53Z Re: Pivot table with two dimensions, calculation question https://community.qlik.com/t5/QlikView/Pivot-table-with-two-dimensions-calculation-question/m-p/357644#M132699 <HTML><HEAD></HEAD><BODY><P>Thank you, that's exactly what I needed.</P></BODY></HTML> Mon, 18 Jun 2012 15:38:05 GMT https://community.qlik.com/t5/QlikView/Pivot-table-with-two-dimensions-calculation-question/m-p/357644#M132699 2012-06-18T15:38:05Z