giannik Posted April 18, 2011 Report Share Posted April 18, 2011 i am trying to create a crosstab view from a list of items using the following code : 'Create and configure the Crosstab data provider Dim cfxCT As ChartFX.WinForms.DataProviders.CrosstabDataProvider = New ChartFX.WinForms.DataProviders.CrosstabDataProvider cfxCT.NullColumnHeading = "N/A" cfxCT.DataSource = Data ' Instruct Chart FX how to use the fields in the Crosstab. Chart1.DataSourceSettings.Fields.Add(New ChartFX.WinForms.FieldMap("BusEventCategory", ChartFX.WinForms.FieldUsage.RowHeading)) Chart1.DataSourceSettings.Fields.Add(New ChartFX.WinForms.FieldMap("CreatedBy", ChartFX.WinForms.FieldUsage.ColumnHeading)) Chart1.DataSourceSettings.Fields.Add(New ChartFX.WinForms.FieldMap("TotalCost", ChartFX.WinForms.FieldUsage.Value)) Chart1.DataSource = cfxCT My issue has to with this line: ChartFX.WinForms.FieldMap("TotalCost", ChartFX.WinForms.FieldUsage.Value) how do i define what aggregation to do with the totalcost field (sum, count , min , max etc ) giannis. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.