topic Cum % Sales Movement in QlikView https://community.qlik.com/t5/QlikView/Cum-Sales-Movement/m-p/437498#M163144 <HTML><HEAD></HEAD><BODY><P>Wondering if I could get some advice...</P><P></P><P>I have been asked to create the attached report in QlikView.</P><P></P><P>Last Year / This Year and progress are straightforward...</P><P></P><P>Not sure how I go about "Cum %Sales Movt" and "Cum £GP Movt"...</P><P></P><P>Any guidance greatly appreciated...</P></BODY></HTML> Wed, 13 Mar 2013 15:31:46 GMT pkelly 2013-03-13T15:31:46Z Cum % Sales Movement https://community.qlik.com/t5/QlikView/Cum-Sales-Movement/m-p/437498#M163144 <HTML><HEAD></HEAD><BODY><P>Wondering if I could get some advice...</P><P></P><P>I have been asked to create the attached report in QlikView.</P><P></P><P>Last Year / This Year and progress are straightforward...</P><P></P><P>Not sure how I go about "Cum %Sales Movt" and "Cum £GP Movt"...</P><P></P><P>Any guidance greatly appreciated...</P></BODY></HTML> Wed, 13 Mar 2013 15:31:46 GMT https://community.qlik.com/t5/QlikView/Cum-Sales-Movement/m-p/437498#M163144 pkelly 2013-03-13T15:31:46Z Re: Cum % Sales Movement https://community.qlik.com/t5/QlikView/Cum-Sales-Movement/m-p/437499#M163145 <HTML><HEAD></HEAD><BODY><P>You can calculate any of these values with expressions. You will have to use some range and inter-record functions to get the accumulated values, but you can do it with separate expressions. I have built an example with these calculations in case it could be useful for you.</P><P></P><P>Juan Gerardo</P></BODY></HTML> Wed, 13 Mar 2013 21:37:29 GMT https://community.qlik.com/t5/QlikView/Cum-Sales-Movement/m-p/437499#M163145 2013-03-13T21:37:29Z