I have this two detailed filter which are set to be required and before autoaggregation:
[To Currency]in('SGD','USD')
[Reference]<>''
However when I apply prompts to choose "reference" and "currency", in the prompt list, it's still showing all the blank reference and other currency like AUD etc...
Why is th case??? :-[ :-[ :-[
If you want the filters in your prompts, then you have to put the filters in the prompt query and not the main report query