Using Formulas for summary rows - excluding custom summary implementation

[Colin]

Can I do the following without using the CustomSummary facility (I find it difficult to implement).

I am using three columns, col 1 is a value, col 2 is a total, col 3 is the percentage (i.e. col3 = col 1 / col 2).

In my summary row, I would like Sum Col 3 = Sum Col 1 / Sum Col 2.

I do not want to apply a SUM: formulat or AVERAGE: formula of the Column 3. Instead I want to summarize Cols 1 & 2 and then formula the col3 in the summary row.

I know I can implement a custom formula, but was hoping a simple formula like this, did not have to go through the Custom Formula implementation.

Thanks

[Administrator]

One way you can try to do this is to handle the QueryCellStyleInfo event, and if the cell being requested is your summary cell, then provide the value you want to see. Here is a sample that computes a weighted average summary using this technique.