TOPN Filter in OBIEE

We want to see the top 10 charges by some practice, this can be achieved by applying the

“is in top” filter to the charge;

But what if you want to retrieve the top 10 results based on some date criteria ?

The workaround for that is to apply an advance filter based on date criteria using “BY” while filtering the charge value.

For that purpose we go to advance and convert the filter to SQL;

Add following to the advance filter;

Finally the filters will look like this;

Cheers ;)