Waterfall Chart | Programmatically Adding ShowTotalSum

[Fidelis]

Hi

Please help me to programmatically add the "ShowTotalSum" bar at the end of a Waterfall chart.

Below is the code I created on page load, but fails to give the "ShowTotalSum" column.

    protected void Page_Load(object sender, EventArgs e)

    {

        Chart1.Visible = true; 

        DataTable dt = new DataTable();

        dt.Columns.Add("xValue");

        dt.Columns.Add("yValue"); 

        dt.Rows.Add(new Object[] { "Opening Policy Count", 1288 });

        dt.Rows.Add(new Object[] { "Exits", -250 });

        dt.Rows.Add(new Object[] { "Expiries", -260 });

        dt.Rows.Add(new Object[] { "New business", 279 });

        dt.Rows.Add(new Object[] { "Reinstatements", 320 });

        Series series = new Series();

        series.XName = "xValue";

        series.YName = "yValue";

        series.Marker.DataLabel.Visible = true;

        series.Marker.DataLabel.EnableContrastColor = true;

        series.Marker.DataLabel.Font.FontSize = "13px";

        series.Marker.DataLabel.TextPosition = TextPosition.Middle;

        series.Marker.DataLabel.Font.FontWeight = ChartFontWeight.Regular;

        series.Tooltip.Visible = true;

        series.Type = SeriesType.Waterfall;

        series.EnableAnimation = true;

        series.PositiveFill = "green";

        Chart3.Series.Add(series);

        Chart3.PrimaryXAxis.LabelIntersectAction = LabelIntersectAction.Wrap;

        Chart3.PrimaryYAxis.LabelFormat = "{value}";

        Chart3.Title.Text = "Active Policy Count Movement Analysis";

        Chart3.DataSource = dt;

        Chart3.DataBind();

        Chart3.Visible = true;

        Chart3.Legend.Visible = false;

    }

[Durga Gopalakrishnan]

Hi Fidelis, 

  

We are analyzing your reported scenario. We will update the further details within two business days(8th January 2021). We appreciate your patience until then. 

  

Regards, 

Durga G 

[Durga Gopalakrishnan]

Hi Fidelis, 

 

We have validated your reported scenario. As of now, we don't have mapping support for showTotalSum and showIntermediateSum properties. We have considered your requirement as improvement and logged a feature request on this. This improvement will be included in any of our upcoming release.You can keep track of an improvement from the feedback portal below. 

  

Feedback Link : https://www.syncfusion.com/feedback/21400/ 

  

If you have any more specification/precise replication procedure or a scenario to be tested, you can add it as a comment in the portal. 

  

Regards, 

Durga G