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


    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.Fields["Loss"].Format = "n0";
    olap.Fields["Loss"].Subtotal = Subtotal.Sum;


    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

Need extra support?

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

Learn More

Forum Channels