Can someone help me filter report? Using 2 fields, "Status" (multiple choices: Active, Active-Sold, Inactive, Closed & Cancelled) & "Year Removed".
Need report to show
ALL [Active + Active-Sold + Inactive clients]
ALL [Closed & Cancelled where Year Removed = 2016]
(Note: Active-Sold includes Year Removed as well; however, I want to show all Active-Sold despite the year removed.)