I need to show a table with Sales rep performance every month. Due to my filters, some reps are not reported on the table because they did not close a deal for that month. I've tried using the ZN method and also right clicking to show missing values, but have had not luck. Anyone know how I can force Tableau to list all Sales reps even if they did not close a deal for the month that I'm reporting on?
pl share some fake data sample to help u