Breaks and Summary

[Doug Finke]

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]

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.