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

Breaks and Summary

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?

1 Reply

AD Administrator Syncfusion Team 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.

Live Chat Icon For mobile
Up arrow icon