topic Re: Calculating Growth in a pivot table in App Development https://community.qlik.com/t5/App-Development/Re-Calculating-Growth-in-a-pivot-table/m-p/732211#M10583 <HTML><HEAD></HEAD><BODY><P>I think this is what you are after:</P><P>formula =((y-x)/x)*100</P><P>x = previous quarter</P><P>y = next quarter</P></BODY></HTML> Thu, 18 Sep 2014 16:40:40 GMT ian_wilson 2014-09-18T16:40:40Z Re: Calculating Growth in a pivot table https://community.qlik.com/t5/App-Development/Re-Calculating-Growth-in-a-pivot-table/m-p/732210#M10582 <HTML><HEAD></HEAD><BODY><P>Hello, I am a newbie and this is my first post. I need to show the growth percentage quarter over quarter and am stuck. Do you have any suggestions of how I would do this? I tried Column-Column/Column ect.. not working. I have attached a screen print.</P></BODY></HTML> Thu, 18 Sep 2014 15:22:53 GMT https://community.qlik.com/t5/App-Development/Re-Calculating-Growth-in-a-pivot-table/m-p/732210#M10582 2014-09-18T15:22:53Z Re: Calculating Growth in a pivot table https://community.qlik.com/t5/App-Development/Re-Calculating-Growth-in-a-pivot-table/m-p/732211#M10583 <HTML><HEAD></HEAD><BODY><P>I think this is what you are after:</P><P>formula =((y-x)/x)*100</P><P>x = previous quarter</P><P>y = next quarter</P></BODY></HTML> Thu, 18 Sep 2014 16:40:40 GMT https://community.qlik.com/t5/App-Development/Re-Calculating-Growth-in-a-pivot-table/m-p/732211#M10583 ian_wilson 2014-09-18T16:40:40Z Re: Calculating Growth in a pivot table https://community.qlik.com/t5/App-Development/Re-Calculating-Growth-in-a-pivot-table/m-p/732212#M10584 <HTML><HEAD></HEAD><BODY><P>The above() function will grab the value from the preceding row. It may help you </P><P></P><P>ex: </P><P></P><P>( Sum(Sales) - above(Sum(Sales),1) ) /&nbsp; above(Sum(Sales),1) </P></BODY></HTML> Fri, 19 Sep 2014 04:31:53 GMT https://community.qlik.com/t5/App-Development/Re-Calculating-Growth-in-a-pivot-table/m-p/732212#M10584 JonnyPoole 2014-09-19T04:31:53Z