For .Net WPF XamPivotGrid:
Can you tell me if Calculated Measures are supported in FlatDataSource. Basically we will like to provide our own calculation for aggregating measures (e.g. weighted average instead of plain average).
I do see that Measures have aggregator which takes enum value and there are references to ByChildreen, ByAccount and Calculated.
I do not see any example and unable to determine how to use it.
Thanks
Hi
Sorry for delay.
You can apply different aggregation function as you use follow code
IOlapViewModel viewModel = pivotGrid.DataSource;
viewModel.SetMeasureAggregator((IMeasureViewModel)viewModel.Measures[0], MeasureAggregator.Count);
viewModel.RefreshGrid();
For now only Sum, Min, Max, Count and Average have implementation. We work to implement and another type of aggregation function in the future releases.
Todor
Does new version (2011), support it?