Hello there,
I'm looking for what might be a bit of a complicated formula, I'm stumped on how to do this in Tableau like I did in Excel. Suppose I have the following dataset:
Sales Rep | Order Number | Revenue ($) |
---|---|---|
001 | A | -$15 |
001 | B | $10 |
002 | C | $15 |
003 | D | -$5 |
004 | E | $10 |
005 | F | $12 |
006 | G | -$10 |
I want a disctinct count of sales reps in this set. They may have more than one order (like rep 001), and if the sum of their orders is a negative value, they are not included in the distinct count of sales reps (so rep 001 would not be included in the distinct count since his total revenue is -$5). The correct distinct count for this dataset would be 3. Any idea how to calculate this?
Pl check screenshot and attached. Here it is:
Thanks
Deepak
If it Helps, pl Mark it Helpful and CORRECT to Close Thread