topic Pivot table division at a collapsed/ expanded level in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-division-at-a-collapsed-expanded-level/m-p/234320#M589325 <HTML><HEAD></HEAD><BODY><P>Sorry John, should have outlined this in my original post. This doesn't work either <span class="lia-unicode-emoji" title=":confused_face:">😕</span></P></BODY></HTML> Mon, 10 May 2010 02:47:23 GMT 2010-05-10T02:47:23Z Pivot table division at a collapsed/ expanded level https://community.qlik.com/t5/QlikView/Pivot-table-division-at-a-collapsed-expanded-level/m-p/234318#M589322 <HTML><HEAD></HEAD><BODY><P>I am applying an exchange rate to individual accounts (if they exist in an exception list) or other accounts (Should they not exist in the list).</P><P>One object is a straight table.</P><P></P><P>The formula for 'Adjusted TB AUD' is</P><P>Sum(Trans) / Rate</P><P>As this does not 'sum', I have set the column total mode as 'Sum of Rows'</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-1577_sourceID:1577" /></P><P>If i modify the formula to Sum(Trans) / Sum(Rate) this creates an incorrect result.</P><P></P><P>The problem I have is when I want to group these accounts in a Pivot table, the Sum(Trans) / Rate formula does not work, and as rows are collapsed / expanded, the results change. This is because the rates 'lose' their relation to the account when grouped.</P><P>Is there a clear solution for this issue?</P><P></P></BODY></HTML> Fri, 07 May 2010 06:49:27 GMT https://community.qlik.com/t5/QlikView/Pivot-table-division-at-a-collapsed-expanded-level/m-p/234318#M589322 2010-05-07T06:49:27Z Pivot table division at a collapsed/ expanded level https://community.qlik.com/t5/QlikView/Pivot-table-division-at-a-collapsed-expanded-level/m-p/234319#M589324 <HTML><HEAD></HEAD><BODY><P>Maybe sum(Trans/Rate)?</P></BODY></HTML> Sat, 08 May 2010 01:16:54 GMT https://community.qlik.com/t5/QlikView/Pivot-table-division-at-a-collapsed-expanded-level/m-p/234319#M589324 johnw 2010-05-08T01:16:54Z Pivot table division at a collapsed/ expanded level https://community.qlik.com/t5/QlikView/Pivot-table-division-at-a-collapsed-expanded-level/m-p/234320#M589325 <HTML><HEAD></HEAD><BODY><P>Sorry John, should have outlined this in my original post. This doesn't work either <span class="lia-unicode-emoji" title=":confused_face:">😕</span></P></BODY></HTML> Mon, 10 May 2010 02:47:23 GMT https://community.qlik.com/t5/QlikView/Pivot-table-division-at-a-collapsed-expanded-level/m-p/234320#M589325 2010-05-10T02:47:23Z