topic Cumulative Values in a pivot table in QlikView https://community.qlik.com/t5/QlikView/Cumulative-Values-in-a-pivot-table/m-p/199230#M58248 <HTML><HEAD></HEAD><BODY><P>I think you are getting total by year, Not sure what you are looking for.</P><P>Please see attached.</P></BODY></HTML> Wed, 23 Jun 2010 21:10:54 GMT 2010-06-23T21:10:54Z Cumulative Values in a pivot table https://community.qlik.com/t5/QlikView/Cumulative-Values-in-a-pivot-table/m-p/199229#M58247 <HTML><HEAD></HEAD><BODY><P>I have a simple pivot table and I want it to show all cumulative values for each year.</P><P>See attached example.</P><P>Would appreciate some help.</P><P>Thanks</P><P></P><P></P></BODY></HTML> Wed, 23 Jun 2010 13:16:56 GMT https://community.qlik.com/t5/QlikView/Cumulative-Values-in-a-pivot-table/m-p/199229#M58247 2010-06-23T13:16:56Z Cumulative Values in a pivot table https://community.qlik.com/t5/QlikView/Cumulative-Values-in-a-pivot-table/m-p/199230#M58248 <HTML><HEAD></HEAD><BODY><P>I think you are getting total by year, Not sure what you are looking for.</P><P>Please see attached.</P></BODY></HTML> Wed, 23 Jun 2010 21:10:54 GMT https://community.qlik.com/t5/QlikView/Cumulative-Values-in-a-pivot-table/m-p/199230#M58248 2010-06-23T21:10:54Z Cumulative Values in a pivot table https://community.qlik.com/t5/QlikView/Cumulative-Values-in-a-pivot-table/m-p/199231#M58249 <HTML><HEAD></HEAD><BODY><P>What I want to see is the value in the months to accumulate down each column in the table so that the *** value for dec in each year is the same as all the months in the year added together.</P></BODY></HTML> Thu, 24 Jun 2010 14:26:20 GMT https://community.qlik.com/t5/QlikView/Cumulative-Values-in-a-pivot-table/m-p/199231#M58249 2010-06-24T14:26:20Z AW:Re: Cumulative Values in a pivot table https://community.qlik.com/t5/QlikView/Cumulative-Values-in-a-pivot-table/m-p/199232#M58250 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>The answer is:</P><H3></H3><P></P><H3>=</H3>sum(Value)+ <BR /><BR /> <H3>If(Not IsNull(Above(sum(Value))),Above(sum(Value)),0)</H3></BODY></HTML> Thu, 24 Jun 2010 15:12:07 GMT https://community.qlik.com/t5/QlikView/Cumulative-Values-in-a-pivot-table/m-p/199232#M58250 brenner_martina 2010-06-24T15:12:07Z