Publish Pivot to web - Column Area issue

H

Henrik

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculated Item causes undue repitition in pivot table 2
Possible to publish excel pivot on the web? 2
How do I prevent access to other page area in pivot table report? 5
How to sort data in data area in a pivot table 1
Column Heading on each row in pivot table 1
Pivot Table Calculations 1
Pivot Table Help 0
Sum data in a column if multi creteria met 4

Top