Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 43
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multi-column sort issue in Pivot Table Mark b. Excel Discussion (Misc queries) 3 February 12th 09 04:47 PM
Multi column sort issue within Pivot table Mark b. Excel Discussion (Misc queries) 0 February 11th 09 02:56 PM
Possible to publish excel pivot on the web? Mikael Lindqvist Excel Discussion (Misc queries) 2 April 18th 08 07:33 AM
Pivot table ROW AREA sreenath205 Excel Discussion (Misc queries) 2 June 22nd 06 02:10 PM
Data Area of Pivot Table and Pivot Charts Missy Charts and Charting in Excel 2 April 13th 06 12:51 AM


All times are GMT +1. The time now is 06:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"