TAggregateField not working with Filters

[Craig]

Hi all,

I've run into a problem.

I'm using a TAggregateField on a ClientDataSet, and when I apply a
Filter to the dataset, the aggregate field does not get updated. It
simply displays the original value, which belongs to the all the
records in the dataset, not the filtered records.

I know I'm setting the filter correctly, as I have attached the
dataset to a Grid and only the filtered records are displayed.

Does anyone have any ideas on how to solve this issue without having
to re-open the table?

Cheers,
Craig.