subtotals on group change

Is there a way to get subtotals of a column in a footer group? How would I go about doing that?

Hi,

You have to calculate the sub-total using a 'onsection' user function. This function has to check itself when the value of the column changes in order to intialize the total.

Yeah, that's what I did. I wanted to know if there was an easier way, since things get pretty hairy when there are many things going on in a report.

fllowup 2 years later.

onsection event is not usable with multiple headergrp since the function is called multiple times with same data when groups change. Getting the totals with a subquery in the main query is looking more and more reasonable.

You might also take a look at the "Aggregate" plugin

It's new since two years I think :)