How to do a filter through SQL Expression in OBIEE Analysis

Hi there,
I am trying to do a simple filter in my analysis. Basically I just need to display a record with a max(sequence_id).
So, in the filter section. I added a filter for the sequence_id column, the operator is 'is equal to/ is in'
and i added sql expression: SELECT MAX(audit_seq_no) FROM audit_results_rep

and I checked the checkbox convert the filter to sql.

But it gave me error when I try to see the result:
Error getting drill information

Can anyone please help me on this.

Thanks
Netty