Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi-column sort issue in Pivot Table | Excel Discussion (Misc queries) | |||
Multi column sort issue within Pivot table | Excel Discussion (Misc queries) | |||
Possible to publish excel pivot on the web? | Excel Discussion (Misc queries) | |||
Pivot table ROW AREA | Excel Discussion (Misc queries) | |||
Data Area of Pivot Table and Pivot Charts | Charts and Charting in Excel |