https://community.qlik.com/t5/QlikView/Partial-Sum-Wrong-For-One-of-the-Expression-with-2-Dimensions/m-p/2463650#M1225835 <P>Can you give a try with dimentionality.&nbsp;</P> <P><SPAN>Dimensionality() returns the "level" of the cell in a pivot. Dimensionality() = 0 would be your grand total.&nbsp;</SPAN></P> Wed, 19 Jun 2024 02:42:08 GMT anat 2024-06-19T02:42:08Z https://community.qlik.com/t5/QlikView/Partial-Sum-Wrong-For-One-of-the-Expression-with-2-Dimensions/m-p/2463644#M1225834 <P>Hi, I have the Pivot table below with 2 Dimension and 2 Expression but the Partial Sum for one of the expression is 0. Below are the Dimension and Expression formula used in this table. Kindly advise. Thank you.</P> <P><STRONG>Dimension</STRONG></P> <P>(1) Source</P> <P>(2)&nbsp;FY Year</P> <P><STRONG>Expression</STRONG></P> <P>(1)&nbsp;tCO₂e =&nbsp;ROUND((SUM(VALUE) * CONVERSION_FACTOR) / 1000)</P> <P>(2)&nbsp;MWh =&nbsp;ROUND((SUM(SM_VALUE) * 10.55) / 1000)</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MCFH93_0-1718763533456.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/168162iBD31553A321E202B/image-size/medium?v=v2&amp;px=400" role="button" title="MCFH93_0-1718763533456.png" alt="MCFH93_0-1718763533456.png" /></span></P> <P>&nbsp;</P> Wed, 19 Jun 2024 02:21:50 GMT https://community.qlik.com/t5/QlikView/Partial-Sum-Wrong-For-One-of-the-Expression-with-2-Dimensions/m-p/2463644#M1225834 MCFH93 2024-06-19T02:21:50Z https://community.qlik.com/t5/QlikView/Partial-Sum-Wrong-For-One-of-the-Expression-with-2-Dimensions/m-p/2463650#M1225835 <P>Can you give a try with dimentionality.&nbsp;</P> <P><SPAN>Dimensionality() returns the "level" of the cell in a pivot. Dimensionality() = 0 would be your grand total.&nbsp;</SPAN></P> Wed, 19 Jun 2024 02:42:08 GMT https://community.qlik.com/t5/QlikView/Partial-Sum-Wrong-For-One-of-the-Expression-with-2-Dimensions/m-p/2463650#M1225835 anat 2024-06-19T02:42:08Z https://community.qlik.com/t5/QlikView/Partial-Sum-Wrong-For-One-of-the-Expression-with-2-Dimensions/m-p/2463654#M1225836 <P>I have tried to use&nbsp;<SPAN>Dimensionality()&nbsp;but the total amount for one of the expression is still 0.</SPAN></P> Wed, 19 Jun 2024 02:50:49 GMT https://community.qlik.com/t5/QlikView/Partial-Sum-Wrong-For-One-of-the-Expression-with-2-Dimensions/m-p/2463654#M1225836 MCFH93 2024-06-19T02:50:49Z https://community.qlik.com/t5/QlikView/Partial-Sum-Wrong-For-One-of-the-Expression-with-2-Dimensions/m-p/2463657#M1225837 <P>Is it working for other metrics?&nbsp;</P> <P>Can I see your logic?&nbsp;</P> Wed, 19 Jun 2024 02:56:09 GMT https://community.qlik.com/t5/QlikView/Partial-Sum-Wrong-For-One-of-the-Expression-with-2-Dimensions/m-p/2463657#M1225837 anat 2024-06-19T02:56:09Z https://community.qlik.com/t5/QlikView/Partial-Sum-Wrong-For-One-of-the-Expression-with-2-Dimensions/m-p/2463661#M1225839 <P>Thanks for your help.</P> <P>I have managed to resolve this issue by using SUM(AGGR()).</P> Wed, 19 Jun 2024 03:08:46 GMT https://community.qlik.com/t5/QlikView/Partial-Sum-Wrong-For-One-of-the-Expression-with-2-Dimensions/m-p/2463661#M1225839 MCFH93 2024-06-19T03:08:46Z