https://community.qlik.com/t5/App-Development/Montly-Accumulation/m-p/1828078#M68193 <P>Hi my friend...&nbsp; I have the next expression on the chart table:</P><P>=(sum({&lt;[ACCNT_CODE]={"8*","9*"}, [FUND]=-{"30*"}, [YearPeriod] = {"$(=YearPeriod)"}, [MonthNumPeriod] = {"&gt;= {'1'} &lt;=$(=max(MonthNumPeriod))"}, [MonthPeriod]=&gt;}[AMOUNT]*-1)) +<BR />(sum({&lt;[ACCNT_CODE]={"8*","9*"}, [FUND]=-{"30*"}, [YearPeriod] = {"$(=YearPeriod-1)"}, [MonthNumPeriod] = {"&gt;=$(=max(MonthNumPeriod)+1)"}, [MonthPeriod]=&gt;}[AMOUNT]*-1))&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JASalinas_0-1628701710370.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/59988iA2CD2126728FEED8/image-size/medium?v=v2&amp;px=400" role="button" title="JASalinas_0-1628701710370.png" alt="JASalinas_0-1628701710370.png" /></span></P><P>Buy I want the sum of the totals to be monthly for Exemplo:</P><P>07-2021 = 28,119,839.16, 06-2021 = 27,362,361.27, 05-2021 = 26,308,362.23 etc...</P><P>The data is in a database sql server.</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 11 Aug 2021 17:11:58 GMT JASalinas 2021-08-11T17:11:58Z https://community.qlik.com/t5/App-Development/Montly-Accumulation/m-p/1828078#M68193 <P>Hi my friend...&nbsp; I have the next expression on the chart table:</P><P>=(sum({&lt;[ACCNT_CODE]={"8*","9*"}, [FUND]=-{"30*"}, [YearPeriod] = {"$(=YearPeriod)"}, [MonthNumPeriod] = {"&gt;= {'1'} &lt;=$(=max(MonthNumPeriod))"}, [MonthPeriod]=&gt;}[AMOUNT]*-1)) +<BR />(sum({&lt;[ACCNT_CODE]={"8*","9*"}, [FUND]=-{"30*"}, [YearPeriod] = {"$(=YearPeriod-1)"}, [MonthNumPeriod] = {"&gt;=$(=max(MonthNumPeriod)+1)"}, [MonthPeriod]=&gt;}[AMOUNT]*-1))&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JASalinas_0-1628701710370.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/59988iA2CD2126728FEED8/image-size/medium?v=v2&amp;px=400" role="button" title="JASalinas_0-1628701710370.png" alt="JASalinas_0-1628701710370.png" /></span></P><P>Buy I want the sum of the totals to be monthly for Exemplo:</P><P>07-2021 = 28,119,839.16, 06-2021 = 27,362,361.27, 05-2021 = 26,308,362.23 etc...</P><P>The data is in a database sql server.</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 11 Aug 2021 17:11:58 GMT https://community.qlik.com/t5/App-Development/Montly-Accumulation/m-p/1828078#M68193 JASalinas 2021-08-11T17:11:58Z