Pivot Table Question

[pritchard.ev]

Hello,

I have a data set that is organized like below where I have an order number along with it's corresponding units, forecast ship date and actual ship date all in a row:

Order # Units Forecast Date Actual Date
1 100 11/10/14 11/11/2014
2 200 11/11/14 11/12/2014
3 300 11/12/14 11/13/2014
4 400 11/13/14 11/14/2014
5 500 11/14/14 11/15/2014

What I am trying to do, is create a pivot table that will combine the dates into a single column and then summarize the units accordingly, like so:

Date Units Forecasted to Ship Units Actually Shipped
11/10/14 100 0
11/11/14 200 100
11/12/14 300 200
11/13/14 400 300
11/14/14 500 400
11/15/14 0 500

Does anyone know if this is possible to do using a single pivot table? I know I can do it using formulas and whatnot but I'm trying to avoid writing that since I'd like to have multiple filters on the table.

Thanks!

Evan

[simarui]

sorry evan, i don't think that's possible, but it would be pretty darn easy to do with formulas and then you could pivot that information to apply the filters. something like =sumif(c:c,a2,b:b) for your units forecasted column and =sumif(d:d,a2,b:b) for the actual # shipped.

if you have any issues or additional questions it would help if you could upload a sample workbook we can work with.