Binding only filters between chart and pivottable?

[Hans Riis]

I've got a chart bound to a pivottable that in turn gets its data from
an SQL-server. I wish to show several measures in the pivottable but
they're not to be shown in the chart.
As it is now, whenever I add or remove a measure from either the chart
or the pivottable the same is applied to the other.
What I'm looking for is showing separate measures in the chart and
pivottable. However, if I change a filter value in the pivottable, the
same filter must apply to the chart.
I'm using OWC10 but will soon be upgrading to OWC11. Is what I'm
trying to do possible?

Thanks, Hans Riis

 

[Alvin Bruney [MVP]]

have a look at the plotallaggregates method

 

[Hans Riis]

Thanks Alvin.

I had a look at the PlotAllAggregates method but the documentation is
scarce at best. Can you provide an example that shows how I can
achieve what I want?

Regards, Hans Riis

 

[Alvin Bruney [MVP]]

thao provided some code this week in this newsgroup. have a look for it

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Thanks Alvin.

I had a look at the PlotAllAggregates method but the documentation is
scarce at best. Can you provide an example that shows how I can
achieve what I want?

Regards, Hans Riis

have a look at the plotallaggregates method

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok