aells
New Member
- Joined
- Apr 22, 2008
- Messages
- 13
OK this is a good one.
I have two pivot tables, each has the same data, except one is Forecast and one is actual.
Columns are month
Rows are Customer and then part number
data is Units and Total Sales.in columnar format.
What I would like to be able to do is create a new pivot table that will take the actuals to date and use them instead of the forecast totals.
Is there a way to do this easily?
I have two pivot tables, each has the same data, except one is Forecast and one is actual.
Columns are month
Rows are Customer and then part number
data is Units and Total Sales.in columnar format.
What I would like to be able to do is create a new pivot table that will take the actuals to date and use them instead of the forecast totals.
Is there a way to do this easily?