Only human beings, such as the auditor, can tell the true story behind the data.
There is really no good way to change the filter with a formula. However, there is a quick fix to remedy the situation.
