https://community.qlik.com/t5/App-Development/how-to-calculate-difference-between-each-month-data/m-p/2065488#M87404 <P>Use this formula in another measure:</P> <P>Measure1-above(TOTAL Measure1)</P> Thu, 27 Apr 2023 23:01:29 GMT Lisa_P 2023-04-27T23:01:29Z https://community.qlik.com/t5/App-Development/how-to-calculate-difference-between-each-month-data/m-p/2065453#M87401 <P>Hi,</P> <P>&nbsp;I have created a PIVOT table for each month. in the same pivot table, as a additional measure, I need to calculate each month difference from previous month. How to find in Pivot table.</P> <P>so Jan records will not change in my 2 nd measure. for Feb 2023 , 1st record should be -5 ( 1390 -1395) , followed by 3(75-72). .. like wise for for all months ( Mar - feb data ) &amp; ( Apr - Mar data )</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Karthick30_0-1682622889002.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/105987i3755D39BAEC55879/image-size/medium?v=v2&amp;px=400" role="button" title="Karthick30_0-1682622889002.png" alt="Karthick30_0-1682622889002.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 15 Nov 2024 21:51:29 GMT https://community.qlik.com/t5/App-Development/how-to-calculate-difference-between-each-month-data/m-p/2065453#M87401 Karthick30 2024-11-15T21:51:29Z https://community.qlik.com/t5/App-Development/how-to-calculate-difference-between-each-month-data/m-p/2065488#M87404 <P>Use this formula in another measure:</P> <P>Measure1-above(TOTAL Measure1)</P> Thu, 27 Apr 2023 23:01:29 GMT https://community.qlik.com/t5/App-Development/how-to-calculate-difference-between-each-month-data/m-p/2065488#M87404 Lisa_P 2023-04-27T23:01:29Z