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