topic Accumulation second dimension in QlikView https://community.qlik.com/t5/QlikView/Accumulation-second-dimension/m-p/428124#M159537 <HTML><HEAD></HEAD><BODY><P>I have two dimensions (customers, year) and I need to show accumulation sales (attached image)</P><P>How to count it?</P><P></P><P></P><P>Thanks</P></BODY></HTML> Mon, 06 May 2013 12:19:58 GMT 2013-05-06T12:19:58Z Accumulation second dimension https://community.qlik.com/t5/QlikView/Accumulation-second-dimension/m-p/428124#M159537 <HTML><HEAD></HEAD><BODY><P>I have two dimensions (customers, year) and I need to show accumulation sales (attached image)</P><P>How to count it?</P><P></P><P></P><P>Thanks</P></BODY></HTML> Mon, 06 May 2013 12:19:58 GMT https://community.qlik.com/t5/QlikView/Accumulation-second-dimension/m-p/428124#M159537 2013-05-06T12:19:58Z Re: Accumulation second dimension https://community.qlik.com/t5/QlikView/Accumulation-second-dimension/m-p/428125#M159538 <HTML><HEAD></HEAD><BODY><P>rangesum(above(sum(Fieldname),0,rowno()))</P></BODY></HTML> Mon, 06 May 2013 12:24:35 GMT https://community.qlik.com/t5/QlikView/Accumulation-second-dimension/m-p/428125#M159538 er_mohit 2013-05-06T12:24:35Z Re: Accumulation second dimension https://community.qlik.com/t5/QlikView/Accumulation-second-dimension/m-p/428126#M159539 <HTML><HEAD></HEAD><BODY><P>Depends on how you want to accumulate. You can try something like rangesum(above(sum(Sales),0,rowno())) to accumulate over customers or rangesum(before(sum(Sales),0,columnno())) to accumulate over years.</P></BODY></HTML> Mon, 06 May 2013 12:27:45 GMT https://community.qlik.com/t5/QlikView/Accumulation-second-dimension/m-p/428126#M159539 Gysbert_Wassenaar 2013-05-06T12:27:45Z Re: Accumulation second dimension https://community.qlik.com/t5/QlikView/Accumulation-second-dimension/m-p/428127#M159540 <HTML><HEAD></HEAD><BODY><P>I want to accumulate over customers for one year</P></BODY></HTML> Mon, 06 May 2013 13:24:24 GMT https://community.qlik.com/t5/QlikView/Accumulation-second-dimension/m-p/428127#M159540 2013-05-06T13:24:24Z