topic RE: Set Analysis in Pivot Table with Partial Sums in QlikView https://community.qlik.com/t5/QlikView/RE-Set-Analysis-in-Pivot-Table-with-Partial-Sums/m-p/187920#M51409 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have a pivot table with the following dimensions....</P><P>branch, div, manager, pname and loanno</P><P>The expressions calculate principle and interest.</P><P>I have partial sums turned on for branch, div, manager, pname. This works great, but i would like to calculate the numbers of loans for each dimension within the partial sums labels. here is a sample of the code in the Manager dimensions partial sums total label....</P><P>='Totals by '&amp; Manager &amp; ' Loans : ' &amp; Sum ({$*Branch*Div*Manager}LoanCounter)</P><P>I want to get all the loans for the manager without selecting the manager field in the pivot table....I am getting the # of loans for all the managers</P><P>I just want to expand the pivot table and have the # of loans show in each partial sums label for each field respectively. Hope this makes sense.</P><P>thanks...</P><P>william</P></BODY></HTML> Sun, 21 Mar 2010 16:41:43 GMT 2010-03-21T16:41:43Z RE: Set Analysis in Pivot Table with Partial Sums https://community.qlik.com/t5/QlikView/RE-Set-Analysis-in-Pivot-Table-with-Partial-Sums/m-p/187920#M51409 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have a pivot table with the following dimensions....</P><P>branch, div, manager, pname and loanno</P><P>The expressions calculate principle and interest.</P><P>I have partial sums turned on for branch, div, manager, pname. This works great, but i would like to calculate the numbers of loans for each dimension within the partial sums labels. here is a sample of the code in the Manager dimensions partial sums total label....</P><P>='Totals by '&amp; Manager &amp; ' Loans : ' &amp; Sum ({$*Branch*Div*Manager}LoanCounter)</P><P>I want to get all the loans for the manager without selecting the manager field in the pivot table....I am getting the # of loans for all the managers</P><P>I just want to expand the pivot table and have the # of loans show in each partial sums label for each field respectively. Hope this makes sense.</P><P>thanks...</P><P>william</P></BODY></HTML> Sun, 21 Mar 2010 16:41:43 GMT https://community.qlik.com/t5/QlikView/RE-Set-Analysis-in-Pivot-Table-with-Partial-Sums/m-p/187920#M51409 2010-03-21T16:41:43Z