Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
800
PivotGrid functions beside Sum
posted

Hi,

Is it possible to use other functions for measures like Avg, Min, Max and Count besides Sum?

Many thanks and best regards,

Tamás

Parents
  • 7922
    posted

    Hi

    For now aggregation functions are supported from FlatDataProvider. If you use it you can apply different aggregation function to the measure you want to. Bellow is the code how to do this:

     

    IOlapViewModel viewModel = pivotGrid.DataSource;

    viewModel.SetMeasureAggregator((IMeasureViewModel)viewModel.Measures[0], MeasureAggregator.Max);

    viewModel.RefreshGrid();

     

    where viewModel.Measures[0] is the first measure in measures list.

    Todor

Reply Children