Hi

As I wrote before you should use aggregator in order to show no numeric data in pivot grid. In sample above I use CountAggregator for this measure and that is why "1' values appears. So to show pure string values you should wirte custorm aggregator. Below is a snippet how to do it.

In the implementation of Evaluate you should write your logic for displayed values.

using System;
using System.Collections.Generic;
using Infragistics.Olap;
 
namespace PivotGrid_11._1_WPF
{
    public class StringAggregator : Aggregator<string>
    {
        public override IAggregationResult<string, string> Evaluate(IAggregationResult<string, string> oldResult, string value)
        {
            throw new NotImplementedException();
        }
 
        public override IAggregationResult<string, string> Evaluate(IAggregationResult<string, string> oldResult, IAggregateable aggregateable, System.Collections.IEnumerable items)
        {
            IList<string> values = new List<string>();
 
            string retValue = "";
            foreach (var item in items)
            {
                string value = (string)aggregateable.GetValue(item);
                values.Add(value);
 
                retValue += value;
            }
 
            // process values in oreder to get the result
            return new SingleResult<string>(retValue);
        }
    }
}

Here is how to change measure metadata

dmd = new DimensionMetadata
{
    //GroupName = "group",
    SourcePropertyName = "EK [ml/g]",
    DimensionType = DimensionType.Measure,
    DisplayName = "EK measure",
    AutoGenerateField = true,
    Aggregator = new StringAggregator()
};

Todor