How should I define the filter to get the following report ?
For a Lead Record type with Job Title field :
IFNULL(Lead."Job Title", 'Not Provided')
Below is how the result is displayed
Full Name Job Title
Sd fsdds Manager
fg sdede Not Provided
de adsd Director
What should I do to get this type of result
Full Name Job Title
Sd fsdds Provided
fg sdede Not Provided
de adsd Provided