https://community.qlik.com/t5/QlikView/Region-Total-Need/m-p/1677018#M449806 <P>try this,</P><P><SPAN>Sum(total&lt;RegionDesc&gt; {&lt;Month,RegionDesc&gt;}Sales_Value_Primary)/1000</SPAN><BR /><SPAN>+</SPAN><BR /><SPAN>Sum(total&lt;RegionDesc&gt;{&lt;Month,RegionDesc&gt;}Sales_Value_ManualAdjustments)/1000</SPAN></P> Wed, 19 Feb 2020 12:00:49 GMT kaushiknsolanki 2020-02-19T12:00:49Z https://community.qlik.com/t5/QlikView/Region-Total-Need/m-p/1677008#M449805 <P>Hi,</P><P>I need the overall total for all months.</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P>Sep - 222443</P><P>..</P><P>..</P><P>..</P><P>Dec - 223443</P><P>&nbsp;</P><P>The value should be coming like this.</P><P>&nbsp;</P><P>Expression:</P><P>Sum({&lt;Month,RegionDesc&gt;}Sales_Value_Primary)/1000<BR />+<BR />Sum({&lt;Month,RegionDesc&gt;}Sales_Value_ManualAdjustments)/1000</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P>&nbsp;</P> Wed, 19 Feb 2020 11:40:13 GMT https://community.qlik.com/t5/QlikView/Region-Total-Need/m-p/1677008#M449805 dineshm030 2020-02-19T11:40:13Z https://community.qlik.com/t5/QlikView/Region-Total-Need/m-p/1677018#M449806 <P>try this,</P><P><SPAN>Sum(total&lt;RegionDesc&gt; {&lt;Month,RegionDesc&gt;}Sales_Value_Primary)/1000</SPAN><BR /><SPAN>+</SPAN><BR /><SPAN>Sum(total&lt;RegionDesc&gt;{&lt;Month,RegionDesc&gt;}Sales_Value_ManualAdjustments)/1000</SPAN></P> Wed, 19 Feb 2020 12:00:49 GMT https://community.qlik.com/t5/QlikView/Region-Total-Need/m-p/1677018#M449806 kaushiknsolanki 2020-02-19T12:00:49Z