https://community.qlik.com/t5/QlikView/Last-three-month-sum-calculation/m-p/1557136#M599248 <P>Hi All,</P><P>&nbsp;</P><P>I need to create a column New3M which will contain sum of sum of last three month value in each records.</P><P>&nbsp;</P><P>input Fields: MATNRWERKS, BRUSD (measure), and ERDAT (datefield).</P><P>New3M (field to be calculated which will contain sum of brusd value of past 3 month record for each MATNRWERKS)</P><P>Suppose if i select ERDAT value = 1-Aug-2018 ,&nbsp; and my matnrwerks value is&nbsp;00000000000201289880118011</P><P>Then New3m value for the 01-Aug-2018 data for matnrwerks value (00000000000201289880118011)</P><P>should be&nbsp;197399.55 as per below data.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 360px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/8130iEBDC2F8BFBA01605/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P> Fri, 15 Mar 2019 11:50:55 GMT sivakumar1994 2019-03-15T11:50:55Z https://community.qlik.com/t5/QlikView/Last-three-month-sum-calculation/m-p/1557136#M599248 <P>Hi All,</P><P>&nbsp;</P><P>I need to create a column New3M which will contain sum of sum of last three month value in each records.</P><P>&nbsp;</P><P>input Fields: MATNRWERKS, BRUSD (measure), and ERDAT (datefield).</P><P>New3M (field to be calculated which will contain sum of brusd value of past 3 month record for each MATNRWERKS)</P><P>Suppose if i select ERDAT value = 1-Aug-2018 ,&nbsp; and my matnrwerks value is&nbsp;00000000000201289880118011</P><P>Then New3m value for the 01-Aug-2018 data for matnrwerks value (00000000000201289880118011)</P><P>should be&nbsp;197399.55 as per below data.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 360px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/8130iEBDC2F8BFBA01605/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P> Fri, 15 Mar 2019 11:50:55 GMT https://community.qlik.com/t5/QlikView/Last-three-month-sum-calculation/m-p/1557136#M599248 sivakumar1994 2019-03-15T11:50:55Z https://community.qlik.com/t5/QlikView/Last-three-month-sum-calculation/m-p/1557212#M599249 Can you please share sample data and exact requirement?<BR />for each you want to calculate data of 3 months right, means in your current format you are showing date in front.<BR /> Fri, 15 Mar 2019 13:48:52 GMT https://community.qlik.com/t5/QlikView/Last-three-month-sum-calculation/m-p/1557212#M599249 Shubham_Deshmukh 2019-03-15T13:48:52Z