I can't find in this sample where the string values from "Amount of sale" added to Measures.

Please write where I can find the code.

Can I download the sample?

Thanks.

Alexander.

Hello,
Here is explained how you can define your custom aggregator. Look for the attached CustomMeasureAggregator.zip.
Also you can look at this sample where you can find how you can implement an aggregator which operates over data with type of string.

Let me know if you have any further questions.

Best regards.
Plamen.

I take the example from Todor Karkelanov in the forum with the DynamicTypeBuilder:
 http://community.infragistics.com/forums/p/46138/248989.aspx#248989
It works fine.

        public void SetFlatDatasource(string displayName, DataTable dataTable)
        {
            DynamicTypeBuilder typeBuilder = new DynamicTypeBuilder
            {
                DynamicAssemblyName = "Test",
                DynamicTypeName = displayName
            };

            IList<DynamicTypePropertyInfo> properties = new List<DynamicTypePropertyInfo>();

            foreach (DataColumn column in dataTable.Columns)
            {
                DynamicTypePropertyInfo propertyInfo = new DynamicTypePropertyInfo
                {
                    PropertyName = column.ColumnName,
                    PropertyType = column.DataType
                };

                properties.Add(propertyInfo);
            }

            Type dynamicType = typeBuilder.GenerateType(properties);

            Type listType = typeof(List<>);

            Type genericListType = listType.MakeGenericType(dynamicType);

            IList list = (IList)Activator.CreateInstance(genericListType);

            foreach (DataRow dataRow in dataTable.Rows)
            {
                object myDynamicInstance = Activator.CreateInstance(dynamicType);

                foreach (DataColumn column in dataTable.Columns)
                {
                    PropertyInfo propertyVal = dynamicType.GetProperty(column.ColumnName);

                    if (dataRow[column] != DBNull.Value)
                        propertyVal.SetValue(myDynamicInstance, dataRow[column], null);
                }

                list.Add(myDynamicInstance);
            }

            FlatDataSource flatDataSource = new FlatDataSource()
            {
                ItemsSource = list,
                Cube = DataSourceBase.GenerateInitialCube(displayName),
                Columns = FlatDataSource.GenerateInitialItems("[Test_NR].[Test_NR]"),
                Rows = FlatDataSource.GenerateInitialItems("[RECORD_NR].[RECORD_NR]"),
                Measures = DataSourceBase.GenerateInitialItems("RX4 [mg/l].RX4 [mg/l]")
            };

            xamPivotGrid.DataSource = flatDataSource;
            xamPivotDataSelector.DataSource = flatDataSource;
        }

But the values from the columns "RX4 [mg/l]" or "TZE [g/ml]" are type of string. That is correct, because
the values in these columns are:
2,5E-04
<0,5E-02
>8,63E-04

I have read: I must have numeric values for measures. That's why I have no items in the Measures group.
Is that correct?
What can I do?

Thanks.
Alexander     

Hi Alexander,

Thank you for writing us.

The reason the pivot grid does not let you drop the Fright in the measures area, (hence the circle with an X), is that you're most probably dragging the dimension Freight, as opposed to the Freight measure, which appears in the Measures expandable group at the top of the list of measures and dimensions.

Please drag the Fright measure from the list of measures in the pivot data selector into the measures area in the pivot grid. This should produce the desired result.

Please see the places you can drag and drop the the Fright measure (blue) and the Freight dimension (red) in the screenshot below:

Let us know if you need any additional assistance.

Best,

Kiril