How can I create a derived measure field dynamically, that calculates the distinct count of another field?
For example, take the flat table below that contains raw data depicting a list of men who went to an events and met women:
Male_Name
Event_Name
Female_Name
Jack
Concert
Ashley
Brittney
Party
Steph
Linda
Mixer
Amber
Bob
Ginger
Gail
Sophia
Chad
The following Pivot Grid shows the Event_Name as columns, Male_Name as rows and Number_Of_Girls_Met as the measure which is derived from the distinct count of Female_Names:
2
1
3
0
How do I make the measure field Number_Of_Girls_Met of type integer, without setting this up in the database?
Hello,
I have been looking into your question and I can suggest you look into the following sample from our website :
https://es.infragistics.com/samples/silverlight/pivot-grid/#/flatdata-aggregators
Here custom aggregators are used.
If you need any further assistance, feel free to ask.
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.