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 - Last Month Sales) .
In the pivot table; I need the formula for Sales Growth. ???
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.
