I have 3 items in my shop. Each item is placed in a separate list. Each list of salespeople with the monthly sales for each person
Let’s assume i run a business with 3 different services. I have a list of employees that sell all 3 services. I have an excel sheet for each service which contains a list of the employees along with their monthly sales numbers for 5 years. I also have another excel sheet that contains the sum of all sales for each employee on a monthly basis for 5 years.
I want to create a dynamic line chart that can allow me to analyze the performance of the employees in the most efficient way. I want to be able to compare certain employee sales and also choose certain dates. I also want to know who outperformed during tough times and who received the highest share of sales during holiday season. If there are any other criteria that would help i would sincerely appreciate it. Thank you in advance to anyone who could help me.
Let’s assume i run a business with 3 different services. I have a list of employees that sell all 3 services. I have an excel sheet for each service which contains a list of the employees along with their monthly sales numbers for 5 years. I also have another excel sheet that contains the sum of all sales for each employee on a monthly basis for 5 years.
I want to create a dynamic line chart that can allow me to analyze the performance of the employees in the most efficient way. I want to be able to compare certain employee sales and also choose certain dates. I also want to know who outperformed during tough times and who received the highest share of sales during holiday season. If there are any other criteria that would help i would sincerely appreciate it. Thank you in advance to anyone who could help me.