Replied 8 September 2017, 2:50 pm EST
Summary rows basically refer to a row in the same grid that holds the results for the various aggregation formulas applied to different columns in the grid. Spread also has the feature of setting various formulas in the column footer that provides different aggregation of the values in the column like sum or average of all the values in a column.
When we set the formulas in a Column Footer, then these formulas are
simply meant to provide an aggregation for all the values in the Column.
The aggregation can be of different types like sum of all the values in
a column, average of all the values in a Column, maximum and minimum
value in a column and more. The SetAggregationType method is used to set
the formulas in a column footer. It has three parameters. First and the
second one specify the row index and column index in the Column Footer
to which the formula is to be applied. Since a column footer can have
multiple rows so you need to specify the row index and column index
specifies to which column are we actually applying the formula. The last
parameter is an enum value where the enum contains all the different
aggregation formulas that can be applied in a column footer. So, the row
index and column index specify the cell in the Column Footer to which
the formula is applied and the enum value tells which formula is
I am attaching a sample which depicts how you can use
SetAggregationType method to calculate the sum of a column, average of a
column and maximum value in a column, kindly have a look at the same.
Hope it will help you. Please let me know if you have any queries