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
