Bind PivotTable to ChartSpace Error

[Roberto Lo Baido]

I set XMLdata property to a Pivot Table in order to populate it with a saved
analysis with 3 measures.
Then i bind a Chartspace with the pivot.

PT.XMLData = myXML;
ChartSpace.DataSource = PT

It all works, but with a problem. The chart only display the first measure
of the pivot table.
How to solve this problem?

 

[Roberto Lo Baido]

I've found the solution:

add the following node to the XMLData of the ChartSpace Object
<xivotAggOrientation>Series</xivotAggOrientation>

 

[Vaibhav]

Hi Robert,
I'm also faced with the same problem. I'm using OWC PivotTable & Chart in my
web page. The chart is the scratch pad for the end user. They can create new
reports by dragging & dropping the fields of their choice. I store the
XMLData from the PivotTable in my database & the chart number from the
Chartspace.

Where & when should i add this node
"<xivotAggOrientation>Series</xivotAggOrientation>" Client side
(javascript) or server side?

Thanks in advance.

Regards,
Vaibhav