How to allow that a filter based on a Simple calculated field displays a values list?
We have created a Simple calculated field in our report doing something like this:
WHEN Productquantity =0 THEN 'EMPTY'
WHEN Productquantity >0 and Productquantity<=10 THEN 'SMALL'
WHEN Productquantity >10 and Productquantity<=100 THEN 'MEDIUM'
And we added this field as a filter with Entry style "List selection". The problem is that the values list displayed in the output is always empty and we don't know how to populate it.
Could you please help us?
Thank you very much.