Four Row Pivot Table


This Software will demonstrate a 'Solution' you can use to build a rolling 4 Row Pivot Table viewing Products with Sales, Forecast, Variance and Tracking %, from Sales and Forecast data using formula and a single Macro to update the Pivot Table week Fields. It allows you to keep your source data in Columns instead of transposing the weeks into Rows (a standard way of using rolling weeks is to have all of the weeks down the Rows and then to add a single 'Weeks' field into the Columns section). This method soes not use any Calculated Items or Fields in the Pivot Table and allows you to Slice any data as long as it is on a 1-2-1 basis with the Products. You are purchasing version 1.1