We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Breaks and Summary

Thread ID:





1989 Dec 9,2002 04:37 PM UTC Dec 9,2002 08:09 PM UTC WinForms 1
Tags: GridControl
Doug Finke
Asked On December 9, 2002 04:37 PM UTC

Does the grid support/plan to support the idea of summary rows based on data changing from row to row? If Column 1 has a list of Regions (North, South, East, West) Column 2 has the a list of departments (Sales, Mkting etc) and Column 3 has net sales. Can the grid be made to show subtotals for Region and Department? Similar to an Excel Pivot Table?

Administrator [Syncfusion]
Replied On December 9, 2002 08:09 PM UTC

The best you can currently do is to sum columns. To do so, you would set the CellType of the cells where you want to see summaries to "FormulaCell", and then add formulas like "=Sum(A1:A4)", display sums of column A, rows 1 through 4. You would have to manually enter similar formulas into any cell where you want to see a summary. It might be possible to add a function to the formula library to that would sum values in one column based on values in another column being equal. I think this is possible, but without sitting down and actually trying to do it, I am not sure what problems you might encounter.


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon