topic Re: Add total for each year in QlikView https://community.qlik.com/t5/QlikView/Add-total-for-each-year/m-p/952361#M327515 <HTML><HEAD></HEAD><BODY><P>Try adding another expression that sums the other four expressions using the rangesum function: rangesum( Column(1), Column(2), Column(3), Column(4))</P></BODY></HTML> Sun, 11 Oct 2015 16:31:18 GMT Gysbert_Wassenaar 2015-10-11T16:31:18Z Add total for each year https://community.qlik.com/t5/QlikView/Add-total-for-each-year/m-p/952360#M327514 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">I'm using a pivot table and I'm displaying the year on the top. I want the total for each year where each year has 4 column. I want to display the amount for these 4 columns in each year or the years selected. </P><P style="font-size: 13.3333px;">see pic </P><P><IMG alt="myApp.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/101665_myApp.png" style="height: 355px; width: 620px;" /></P></BODY></HTML> Sun, 11 Oct 2015 10:24:17 GMT https://community.qlik.com/t5/QlikView/Add-total-for-each-year/m-p/952360#M327514 2015-10-11T10:24:17Z Re: Add total for each year https://community.qlik.com/t5/QlikView/Add-total-for-each-year/m-p/952361#M327515 <HTML><HEAD></HEAD><BODY><P>Try adding another expression that sums the other four expressions using the rangesum function: rangesum( Column(1), Column(2), Column(3), Column(4))</P></BODY></HTML> Sun, 11 Oct 2015 16:31:18 GMT https://community.qlik.com/t5/QlikView/Add-total-for-each-year/m-p/952361#M327515 Gysbert_Wassenaar 2015-10-11T16:31:18Z Re: Add total for each year https://community.qlik.com/t5/QlikView/Add-total-for-each-year/m-p/952362#M327516 <HTML><HEAD></HEAD><BODY><P>Thanks works great <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Mon, 12 Oct 2015 04:39:53 GMT https://community.qlik.com/t5/QlikView/Add-total-for-each-year/m-p/952362#M327516 2015-10-12T04:39:53Z