An OnFilterChangeEnum expression that specifies what's happen once the user
applies a filter.
By default, the OnFilterChange property is
exFilterUpdateTotals. In other words, the total/subtotal fields are updated so
it gets data only for visible rows, not for the entire data. Use the
OnFilterChange property to hide the total/sub-total fields when a filter is
applied.
The OnFilterChange property can do one of the following:
updates the total/sub-total fields, so it gets the value for the visible
rows only, not for the entire data
hide the total/sub-total fields, once the user applies the filter