https://community.qlik.com/t5/App-Development/Month-on-Month-growth-in-Pivot-table/m-p/1796357#M62463 <P>I have designed a Pivot table where the Dimensions are Item Category (Rows) and Month (Columns). The measures are Sales Value, Sales Qty and Sales Growth (Current Month Sales -&nbsp; Last Month Sales) .&nbsp;</P><P>In the pivot table; I need the formula for Sales Growth. ???</P><P>Sales Value and Sales Qty formula is easy. I make a year total formula and when used in pivot, it break the year total to month totals.&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 17:19:27 GMT Mohammad_Adnan_Ansari 2024-11-16T17:19:27Z https://community.qlik.com/t5/App-Development/Month-on-Month-growth-in-Pivot-table/m-p/1796357#M62463 <P>I have designed a Pivot table where the Dimensions are Item Category (Rows) and Month (Columns). The measures are Sales Value, Sales Qty and Sales Growth (Current Month Sales -&nbsp; Last Month Sales) .&nbsp;</P><P>In the pivot table; I need the formula for Sales Growth. ???</P><P>Sales Value and Sales Qty formula is easy. I make a year total formula and when used in pivot, it break the year total to month totals.&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 17:19:27 GMT https://community.qlik.com/t5/App-Development/Month-on-Month-growth-in-Pivot-table/m-p/1796357#M62463 Mohammad_Adnan_Ansari 2024-11-16T17:19:27Z