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.
Unfortunately, activation email could not send to your email. Please try again.

Breaks and Summary

Thread ID:





1989 Dec 9,2002 11:37 AM Dec 9,2002 03:09 PM Windows Forms 1
Tags: GridControl
Doug Finke
Asked On December 9, 2002 11:37 AM

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 03:09 PM

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.

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.