OLAP Grid: values are not summed

Posted by: abellisomi on 17 March 2020, 2:45 am EST

  • Posted 17 March 2020, 2:45 am EST

    Hello,

    I am trying to load some values in a OLAP grid using a DataSet - each DataRow contains only decimal values.

    When I try to do an aggregation with a SUM it does not seem to work as I only can do a COUNT subtotal.

    I even tried to force the formatting this way


    var olap = OlapPage.OlapPanel.OlapEngine;
    // bind OLAP page to data
    olap.DataSource = ds.Tables[0].DefaultView;

    // apply update to view
    olap.BeginUpdate();
    olap.ColumnFields.Add("BusinessUnitId");
    olap.FilterFields.Add("RiskId");
    olap.RowFields.Add("Year");

    olap.ValueFields.Add("Loss");
    olap.Fields["Loss"].Format = "n0";
    olap.Fields["Loss"].Subtotal = Subtotal.Sum;

    olap.EndUpdate();


    The grid only shows a bunch of zeroes.
    What am I missing?

    Thank you
  • Replied 17 March 2020, 6:49 am EST

    Sorry - the entry has been duplicated, it seems your SPAM filter is acting up a bit.
    Please feel free to close one of the post.
  • Marked as Answer

    Replied 18 March 2020, 3:34 pm EST

    Answered here: https://www.grapecity.com/forums/wpf-edition/olap-grid-values-are-not-s

    ňúPragati
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels