I'm running into a problem trying to format the pivot tables and/or the MS
Add-in for excel.

I need to format a report as follows:

Sales Units:
WEEK NUMBER
Measures for Just 200504
UPC 200501 200502 200503 200504 In Stock
On Order Qty Shipped
0001 101 105
170 52 44
0002 106 109
193 43 213
0003 104 120
142 33 121
0004 102 150 etc.
250 90 55

I can easily do the first part, using a dimension for UPC and Week Number,
but it's appending a single week on the end and three other measures. I'd
really like to do this in one pivot table so the user can drill up and down.
I'm also evaluation o2olap for this purpose. Has anyone been able to do this
with any of the three products I've mentioned?

Thank you very much,
Malcolm