topic Re: Accumulation in Pivot in QlikView https://community.qlik.com/t5/QlikView/Accumulation-in-Pivot/m-p/661408#M1055515 <HTML><HEAD></HEAD><BODY><P>This is a really stupid question I'm sure, but I require a total column too (which i know will be the same as the most recent date but I'm being asked for it). Surely i can add total to a pivot?</P></BODY></HTML> Mon, 20 Oct 2014 12:52:31 GMT kevbrown 2014-10-20T12:52:31Z Accumulation in Pivot https://community.qlik.com/t5/QlikView/Accumulation-in-Pivot/m-p/661402#M1055508 <HTML><HEAD></HEAD><BODY><P>I'm looking to create a pivot table over months that sums a field called "ukmpsmr_risk_prem_by_uw.PBU_NET_USD" to create an accumulation.</P><P></P><P>Easy?</P><P></P><P></P><P></P><P><BR /> </P></BODY></HTML> Mon, 20 Oct 2014 09:56:11 GMT https://community.qlik.com/t5/QlikView/Accumulation-in-Pivot/m-p/661402#M1055508 kevbrown 2014-10-20T09:56:11Z Re: Accumulation in Pivot https://community.qlik.com/t5/QlikView/Accumulation-in-Pivot/m-p/661403#M1055509 <HTML><HEAD></HEAD><BODY><P>hi </P><P>check this thread</P><P><A href="https://community.qlik.com/thread/71493">Accumulation for Pivot Table</A></P></BODY></HTML> Mon, 20 Oct 2014 10:01:35 GMT https://community.qlik.com/t5/QlikView/Accumulation-in-Pivot/m-p/661403#M1055509 arulsettu 2014-10-20T10:01:35Z Re: Accumulation in Pivot https://community.qlik.com/t5/QlikView/Accumulation-in-Pivot/m-p/661404#M1055511 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">rangesum(above(sum(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">ukmpsmr_risk_prem_by_uw.PBU_NET_USD</SPAN>), 0 , RowNo())))</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">like this<BR /></SPAN></P></BODY></HTML> Mon, 20 Oct 2014 10:02:56 GMT https://community.qlik.com/t5/QlikView/Accumulation-in-Pivot/m-p/661404#M1055511 arulsettu 2014-10-20T10:02:56Z Re: Accumulation in Pivot https://community.qlik.com/t5/QlikView/Accumulation-in-Pivot/m-p/661405#M1055512 <HTML><HEAD></HEAD><BODY><P>That works if I have Month as rows but i want Month as column headers.</P></BODY></HTML> Mon, 20 Oct 2014 10:57:35 GMT https://community.qlik.com/t5/QlikView/Accumulation-in-Pivot/m-p/661405#M1055512 kevbrown 2014-10-20T10:57:35Z Re: Accumulation in Pivot https://community.qlik.com/t5/QlikView/Accumulation-in-Pivot/m-p/661406#M1055513 <HTML><HEAD></HEAD><BODY><P>instead of above try before</P></BODY></HTML> Mon, 20 Oct 2014 11:01:05 GMT https://community.qlik.com/t5/QlikView/Accumulation-in-Pivot/m-p/661406#M1055513 arulsettu 2014-10-20T11:01:05Z Re: Accumulation in Pivot https://community.qlik.com/t5/QlikView/Accumulation-in-Pivot/m-p/661407#M1055514 <HTML><HEAD></HEAD><BODY><P>Superb and changing RowNo to ColumnNo it's worked a treat, thanks</P></BODY></HTML> Mon, 20 Oct 2014 11:03:46 GMT https://community.qlik.com/t5/QlikView/Accumulation-in-Pivot/m-p/661407#M1055514 kevbrown 2014-10-20T11:03:46Z Re: Accumulation in Pivot https://community.qlik.com/t5/QlikView/Accumulation-in-Pivot/m-p/661408#M1055515 <HTML><HEAD></HEAD><BODY><P>This is a really stupid question I'm sure, but I require a total column too (which i know will be the same as the most recent date but I'm being asked for it). Surely i can add total to a pivot?</P></BODY></HTML> Mon, 20 Oct 2014 12:52:31 GMT https://community.qlik.com/t5/QlikView/Accumulation-in-Pivot/m-p/661408#M1055515 kevbrown 2014-10-20T12:52:31Z