Pivot Table - is this possible?

[thart21]

Hi,

I have a pivot table that currently looks like this

Excel Workbook
	A	B	C	D	E	F
12	Product	Available at DC	ETA	2XL	L	M
13	A	0	No ETA	224	896	784
14	A	0	No ETA	141	563	493
15	A	0	4/15/2011	115	461	403
16	B	0	No ETA	160	640	560
17	B	0	4/5/2011		380	700
18	B	174	Available at DC
19	B	185	Available at DC
Sheet1

Excel 2007

The data that is under the columns 2XL,L, M, etc. is now just showing qty's for "Unavailable" or ones that list "No ETA" or a date.. I also need to have the field "Available at DC" to be under these same columns with the data broken out by size just as the "Unavailable" is, but I need it to be in the same columns, not another set of the same "size" column as below.

Excel Workbook
	A	B	C	D	E	F	G
1	Product	ETA	2XL	L	M	S	XL
2	A	No ETA	224	896	784	364	532
3	A	No ETA	141	563	493	229	334
4	A	4/15/2011	115	461	403	187	274
5	B	No ETA	160	640	560	260	380
6	B	4/5/2011		380	700	520
7	B	Available at DC		174			0
8	B	Available at DC			185
Sheet1

Excel 2007

Is this even possible to do? I've searched on several sites with no luck. I can get them like the below example, but need it like above.

Excel Workbook
	A	B	C	D	E
1		L		M
2	ETA	Unasgn Qty	Available at DC	Unasgn Qty	Available at DC
3	No ETA	224	0	896	0
4	No ETA	141	0	563	0
5	4/15/2011	115	0	461	0
6	No ETA	160	0	640	0
7	4/5/2011			380	0
8	Available at DC		174		185
Sheet1

Excel 2007

Thanks in advance for any help you could give.

Toni

 

[thart21]

Update - a workaround - created separate crosstab queries in Access, created a new table and exported it to Excel, then created my pivot.

I would love to still find out if this can be done in Excel so I can avoid this additional Access step.

Thanks!

Toni