I have three dates here; orderdate, billdate, and paymentdate. I have to use SET analysis and need to filter out these dates according to the selection please help. I am new to SET Analysis. Can someone help me apply the below filters in SET.
Thanks in advance,
1) orderdate <= selected year/month or is null
2) billdate >= selected year/month or is null
3) Transaction billed GrossAmount is not $0
4) paymentdate is in the selected year/month
5) GrossAmount = > Contractlinebilling