hi,i am now using vol 11.2,
am binding the datachart with pivotgrid.
<ig:XamDataChart ToolTipStyle="{StaticResource ToolTipStyle}" Grid.Column="0" Grid.Row="0" x:Name="DataChart" VerticalZoombarVisibility="Collapsed" HorizontalZoombarVisibility="Visible" HorizontalZoomable="True" VerticalZoomable="False" WindowResponse="Immediate"
DefaultInteraction="DragPan" Background="{x:Null}" CrosshairVisibility="Collapsed"
Cursor="Hand" GridMode="BehindSeries" PlotAreaBackground="#e6def5" Margin="3,2,10,0">
<ig:XamDataChart.Axes>
<ig:NumericYAxis x:Name="yAxis">
<ig:NumericYAxis.LabelSettings>
<ig:AxisLabelSettings Extent="25" Padding="0,5,0,0"/>
</ig:NumericYAxis.LabelSettings>
</ig:NumericYAxis>
<ig:OlapXAxis
x:Name="xAxis"
DataSource="{StaticResource FlatDataSource}"
OlapAxisSource="Columns"
AutoGenerateSeries="True"
YAxis="{Binding ElementName=yAxis}"/>
</ig:XamDataChart.Axes>
<ig:XamDataChart.Series>
</ig:XamDataChart.Series>
</ig:XamDataChart>
<ig:XamPivotGrid Grid.Column="0" Grid.Row="2" RowHeaderStyle="{StaticResource RowHeaderCellStyle}" AllowCompactLayout="True" DataSource="{StaticResource FlatDataSource}" x:Name="pivotGrid" AllowHeaderColumnsSorting="False" AllowHeaderRowsSorting="False" Padding="5,25,0,0">
<ig:XamPivotGrid.EditSettings>
<ig:EditSettings AllowCellEdit="True"/>
</ig:XamPivotGrid.EditSettings>
when i remove the datachart, i can edit the cells in the grid, but when i put it again, i cant edit :S
so whats the problem? i want to edit the cells in the pivot grid and c the changes in the chart.
and is it possible to have stackedcolumnseries??
Hi
To be able to edit the cells in pivot grid you should set AllowCellEdit to true (which you did) and to specify measures for which editing is allowed in the EditableMeasures collection. i can see it from snippet.
You can read more about cell editing here
RegardsTodor
i already set the measure
this.pivotGrid.DataSource.Measures.CollectionChanged += Measures_CollectionChanged;
void Measures_CollectionChanged(object sender, NotifyCollectionChangedEventArgs e) { switch (e.Action) { case NotifyCollectionChangedAction.Add: AggregatorType aggregatorType = (AggregatorType.Sum); foreach (IMeasureViewModel mvm in e.NewItems) { this.pivotGrid.EditSettings.EditableMeasures.Add(mvm.Measure); this.pivotGrid.DataSource.SetMeasureAggregator( mvm, AggregationHelper.GetDefaultAggregator(typeof(double), aggregatorType) ); } break; case NotifyCollectionChangedAction.Remove: foreach (IMeasureViewModel mvm in e.OldItems) { this.pivotGrid.EditSettings.EditableMeasures.Remove(mvm.Measure); } break; } }
when i put only the pivot grid, it works, i can edit the cell,
but when i put the chart and bind it to the same datasource as the grid, then i cant edit anymore
Sorry, but I could not reprouce your issue.I have atached a sample where it works
Todor
Thanks,
since there is only Column series in olap axis, how can i make it to bind stacked column datachart with pivotgrid, its really urgent, the whole application depends on this.
i saw the sample http://samples.infragistics.com/sldv/RunSamples.aspx?cn=pivot-grid#/pivot-grid/pivot-grid-and-bar-charts
can i replicate this with datachart??
what can i write instead of this:
this.pieChart.Series.Add(new Series() { DataSource = cells, Label = row.Caption, DataMapping = "Value=Value;Label=Label", ChartType = ChartType.StackedColumn });