Pivot table

[datahelp]

what's the best way to get a Pivot TAble to calculate an estimate of 4Q sales using known sales for 1Q-3Q. The calculation needs to take into account different products and regions.
Many thanks

 

[General Ledger]

datahelp,

I don't know exactly but here are some thoughts.

You might need to use the FORECAST function which, "calculates, or predicts, a future value by using existing values. The predicted value is a y-value for a given x-value. The known values are existing x-values and y-values, and the new value is predicted by using linear regression. You can use this function to predict future sales, inventory requirements, or consumer trends."

You can add a Calculated Field to a pivot table. Make sure a cell inside the pivot table is active. Select the Pivot Table menu item, then Formulas, then Calulated Fields. Here you may be able to create a formula that calculates the forecasted sales.

Best of luck,

General Ledger

 

[datahelp]

General Ledger Re: Pivot table

Thank you...that's a start.