Run into a request where we have a Bar chart that shows our Sales Reps who have a certain # of accounts over 2,000 in Profit this year. Some reps have accounts that meet this threshold and others do not. What I need to do is be able to show the reps that do not have any alongside of reps who do.
Right now We're doing a Countd(Account #) and since some reps that is 0 for the filters we have in place, they're not showing. How can I get them to show up even if they have 0?