Problems with connection of ChartSpace and PivotTable

[lunatic]

Hello!



I have ChartSpace connected with PivotTable through DataSource property.
When i add totals to PivotTable in a programming way, totals are not
correctly added to ChartSpace.



For example, i have 2 cube measures: TPrise and TNetto. I clear totals
in PivotTable and then add them both. So i expect the same totals be in
ChartSpace, but instead no totals are added, or only TPrise is added
(though both measures are bolded in ChartSpace's list - just like they
were added)



Please help, what's the problem and how to make them
automatically added?



Thanx a lot

 

[Thao Moua [ms]]

This is a very interesting case. When the chart is
bounded to a pivotlist control and calculations are
performed on the pivotlist side these aggegrates do not
propagate to the chart. So you must tell the chart
refresh itself.

set c=webchart.constants
webchart.PlotAllAggregates = c.chPlotAggregatesSeries

Thao Moua
OWC Webchart Support