Publish Pivot to web - Column Area issue
 

Hello,

Today we have a pivot table in excel2003 that a data structure like this:

DATA Company (column area)
StockQty
StockValue
XX company YY company ZZ company XX company
ItemID 100 200 300 22222

When the above is publish as an interactive site (web components) - the DATA
area is removed from the column area which results in that the layout will be
as below:

Company (column area)
XX company YY company
StockQTY StockValue PO value StockQTY StockValue
PO value
ItemID 100 22222 300 200
333333 45335

Why is the DATA(including all the measures) removed from the column area
when it's published? - and is there a way to prevent this behaviour...? I
really would like to get the DATA visible in the coloumn area again - so any
help is very much appriciated.

Thanks
H