I don't think that's the same thing I'm asking for Nikolov. I specifically need a field that would show up in the "Measures" section of the tree that you will just have to drag into the measures section of the pivot grid. That Field should be, in sql terms, a DISTINCT COUNT of an existing field.

Plamen, your suggestion sounds more like what we need. This is what I did so far. All the default fields show up, I did not get any errors BUT I don't see the measure "Female Count" showing up on the data selector. Am I missing anything? I'm using code behind because I'm having a hard time getting the XAML binding to work, that'll be a separate post later.

CubeMetadata cubeMetadata = new CubeMetadata();
    cubeMetadata.DataTypeFullName = typeof(BoyMeetsGirl).FullName;               
    cubeMetadata.DisplayName = "Boy Meets Girl";
  cubeMetadata.DimensionSettings.Add(
        new DimensionMetadata(){
            SourcePropertyName ="Female_Name",
      DimensionType = DimensionType.Measure,
      DisplayName = "Female Count",
      DisplayFormat ="{}{0}",
      AggregatorType = AggregatorType.Count });

FlatDataSource dataSource = new FlatDataSource();
dataSource.ItemsSource = DatingViewModel.BoyMeetsGirlObservableCollection;
dataSource.CubesSettings.Add(cubeMetadata);
pivotDataSelectorSampleDetails.DataSource = dataSource;
pivotGridSampleDetails.DataSource = dataSource;

NOTE: with all my code and solutions, please refer to my original posting for the fictional flat data source.

As I was looking at the available AggregatorTypes, I realized that DistinctCount fits more of what I'm trying to accomplish. However, I get a compile time error saying :  'Infragistics.Olap.AggregatorType' does not contain a definition for 'DistinctCountCount' even though it shows up on intellisense.

please ignore that last post, it's late and i didn't notice the double "count"

Hello,

The cube settings should be added before items source is set because all metadata is processed when items source is set.

FlatDataSource dataSource = new FlatDataSource();

dataSource.CubesSettings.Add(cubeMetadata);
dataSource.ItemsSource = DatingViewModel.BoyMeetsGirlObservableCollection;

Regards.
Plamen.

I have modified the TopCountAggregator so it can follow different behaviors now. You can find a working sample attached which I hope will cover your needs.

Best regards.
Plamen.

Plamen, YOU ARE A GENIUS!!!

This is exactly what I need. Although I was hoping that your first suggestion would work, because it made a lot of sense. I am happy with the solution you've provided. It's given me extra things to add to the application.

Thank You!!!

Looks like something that I am looking too. I have a class Customer. How can I expose the property(Amount) of Order as a measure, if I create a Cube out of List of Customers(basically FlatDataSource).

public class Customer

{

  string Name {get; set;}

  Order CustOrder {get; set;}

}

public Order

{

  string OrderNum {get; set;}

  double Amount {get; set;}

}