Using filter removes the null value

[Subhasmita]

I am not sure if this type of solution already exist. But any insight would be of great help if not discussed already in the forum..

Problem Scenario:

I have sales and customer table and there are few records which has sales but no customer data. Now on front end, i need to filter out on particular customer record which is also resulting in filtering out the sales for null customer record. I need the sales for null customer part of total sales .

[MayilVahanan]

Hi

Can you provide sample data n expected result to achieve? If my understanding correct, if you want to display the null customer info for selection, you can try like below

NullAsValue CustomerId;

Set NullValue = 'NULL';