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.Skins = Skins.Metro; this.pivotChart1.ShowLegend = true; this.pivotChart1.AllowDrillDown = true; this.pivotChart1.AxisFieldSection.Visible = true; this.pivotChart1.LegendFieldSection.Visible = true; this.pivotChart1.FilterFieldSection.Visible = true; this.pivotChart1.ValueFieldSection.Visible = true; this.pivotTableFieldList1.AssociateWith(this.pivotChart1); }
/// <summary> /// The Grid settings Customization /// </summary> private void InitializePivotGrid() { // Adding ItemSource to the Control pivotGridControl1.ItemSource = ProductSalesData.GetSalesData(); // Adding PivotRows to the Control pivotGridControl1.PivotRows.Add(new PivotItem { FieldMappingName = "Product", TotalHeader = "Total" }); pivotGridControl1.PivotRows.Add(new PivotItem { FieldMappingName = "Date", TotalHeader = "Total" }); // Adding PivotColumns to the Control pivotGridControl1.PivotColumns.Add(new PivotItem { FieldMappingName = "Country", TotalHeader = "Total" }); pivotGridControl1.PivotColumns.Add(new PivotItem { FieldMappingName = "State", TotalHeader = "Total" }); // Adding PivotCalculations to the Control pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo { FieldName = "Amount", Format = "$ #,##0.00", SummaryType = SummaryType.DoubleTotalSum }); pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo { FieldName = "Quantity", Format = "#,##0" }); //tab key navigation set as false to move the next control pivotGridControl1.TableControl.WantTabKey = false; pivotGridControl1.ShowPivotTableFieldList = true; pivotGridControl1.ShowGroupBar = true; }