How to create a filter where the particular column doesnt exist?
I dont have a column called status which consists of whether the employee has been assigned or not - assigned to Project. But i explicitly want to create a column from script side as Status - Assigned / Not - Assigned as a filter and once it is selected the Particular name should be displayed. How it can be achieved? I tried with the mapping load it gives the names of assigned. But I dont want in that case. Instead i want the filter to contain to assigned and not assigned and based on that selection particular name should be displayed.