topic Re: Calculating a percentage change between two numbers in a pivot table in App Development https://community.qlik.com/t5/App-Development/Calculating-a-percentage-change-between-two-numbers-in-a-pivot/m-p/23693#M1602 <HTML><HEAD></HEAD><BODY><P>May be try this</P><P></P><P><STRONG>Count(Measure)/Before(Count(Measure)) - 1</STRONG></P></BODY></HTML> Thu, 14 Jun 2018 01:50:02 GMT sunny_talwar 2018-06-14T01:50:02Z Calculating a percentage change between two numbers in a pivot table https://community.qlik.com/t5/App-Development/Calculating-a-percentage-change-between-two-numbers-in-a-pivot/m-p/23692#M1601 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/205122_Capture.JPG" style="height: auto;" /></P><P>How do I calculate the percentage change between the totals and by each territory? So for example (126-140)/140=-10.00%</P><P></P><P>Thanks</P></BODY></HTML> Wed, 13 Jun 2018 20:50:45 GMT https://community.qlik.com/t5/App-Development/Calculating-a-percentage-change-between-two-numbers-in-a-pivot/m-p/23692#M1601 pete_bolin 2018-06-13T20:50:45Z Re: Calculating a percentage change between two numbers in a pivot table https://community.qlik.com/t5/App-Development/Calculating-a-percentage-change-between-two-numbers-in-a-pivot/m-p/23693#M1602 <HTML><HEAD></HEAD><BODY><P>May be try this</P><P></P><P><STRONG>Count(Measure)/Before(Count(Measure)) - 1</STRONG></P></BODY></HTML> Thu, 14 Jun 2018 01:50:02 GMT https://community.qlik.com/t5/App-Development/Calculating-a-percentage-change-between-two-numbers-in-a-pivot/m-p/23693#M1602 sunny_talwar 2018-06-14T01:50:02Z