Sum totals and filtering

[Guest]

I have a tabular form where one of the columns has a sum total underneath the
column at the bottom of the rows. It is working correctly except when I
apply a filter. When I apply a filter the sum continues to reflec the total
for all rows instead of just the filtered rows. Is there a way to deal with
or correct this so that it reflects the totals for just the filtered rows?

 

[Guest]

It has been some time since I posted this message. Would someone give it a
shot please.