private void InitializeGrid()
{
pivotGridControl1.GridVisualStyles = GridVisualStyles.Metro;
pivotGridControl1.ItemSource = ProductSalesData.GetSalesData();
//used to add PivotRows.
pivotGridControl1.PivotRows.Add(new PivotItem {
FieldMappingName = "Product", TotalHeader = "Total"
});
pivotGridControl1.PivotRows.Add(new PivotItem {
FieldMappingName = "Date", TotalHeader = "Total"
});
//used to add PivotColumns.
pivotGridControl1.PivotColumns.Add(new PivotItem {
FieldMappingName = "Country", TotalHeader = "Total"
});
pivotGridControl1.PivotColumns.Add(new PivotItem {
FieldMappingName = "State", TotalHeader = "Total"
});
//used to add PivotCalculations.
pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo {
FieldName = "Amount", Format = "C", SummaryType = SummaryType.DoubleTotalSum
});
pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo {
FieldName = "Quantity", Format = "#,##0"
});
//shows the pivot table field list.
pivotGridControl1.ShowPivotTableFieldList = true;
pivotGridControl1.ShowGroupBar = true;
pivotGridControl1.TableControl.FreezeHeaders = true;
}
private void InitializePivotChart()
{
// Adding ItemSource to the Control
this.pivotChart1.ItemSource = ProductSalesData.GetSalesData();
// Adding PivotAxis to the Control
this.pivotChart1.PivotAxis.Add(new PivotItem {
FieldMappingName = "Product", TotalHeader = "Total"
});
this.pivotChart1.PivotAxis.Add(new PivotItem {
FieldMappingName = "Date", TotalHeader = "Total"
});
// Adding PivotLegend to the Control
this.pivotChart1.PivotLegend.Add(new PivotItem {
FieldMappingName = "Country", TotalHeader = "Total"
});
// Adding PivotCalculations to the Control
this.pivotChart1.PivotCalculations.Add(new PivotComputationInfo {
FieldName = "Quantity", Format = "#,##0"
});
this.pivotChart1.PrimaryXAxis.InterlacedGrid = this.checkBox1.Checked;
this.pivotChart1.PrimaryYAxis.InterlacedGrid = this.checkBox2.Checked;
}