Filters on Column Selector
In a nutshell: I am trying to develop a 'delinquency' report.
Delinquent records are defined by records that have not been 'closed' as of today (ie. Estimated Order Intake Date is in the past or '<NOW()') or when either of the following is equal to '0': Chance of Success, Chance of Execution, or Sales Volume.
I want the the default report to show all records that have either of the above criteria as true. BUT I would also like the user to select the type of condition they would specifically want to see ie. if they want to see which records have a Chance of Success = 0, they click on the drop--down (very likely a column selector) and select 'Chance of Success' and the report displays the records that have the Chance of Success = 0 and so forth with other columns.