Sales performance by year by employee

[Buatti]

Hi,

I need to summarise the sales performance for an employee dimension where I have the employees listed in one query and the sales by year in another query. This second query only shows employees where they made sales.

I need a column to show sales performance e.g. "high", "low", ",no sales" for each employee. But how can I show this for the employees with no sales as they won't be in the sales query?

If I add the status in the sales query, it comes up blank for employees with no sales as there is no related record between the employee table and sales table. I don't want to merge these queries because it will duplicate the employee records for each year in the sales query. My report page will only ever be filtered to one single year.

[olgad]

Hi, if you add +0 to your sales measure 

Sales=Sum(Revenue)+0

Then those employees will show up in your sales table, if you dont beed them in your visuals you will have to filter them out, but this way they will be included into mapping low