I have a field called Project Name in the Universe.

I want to use this field as a parameter for retrieving the projects on the report.

 

I tried creating a dynamic parameter using the Parameters -> New.

But this doesn’t work.

So I created a query filter as In List.

 

Now I need to have a parameter ‘ALL’ which is not in the database, but the user needs the flexibility to select ‘ALL’ to see all the data.

How should I do this?