Forum Discussion
renatopnovaes
5 years agoHelper I
Group Items Goals
Hi Friends! I have a sales database (EXCEL) with column with product name, salesperson, supervisor, date of sale, product group, value etc. The company is holding an event, if the sellers sell 3 dif...
renatopnovaes
5 years agoHelper I
i need sell 4 itens from differents groups for Supermercado 1-4 group, but there will be customer channels that will have different goals. Each salesperson has to sell these products to get points and earn commission.
CTozzi
5 years agoResolver I
- renatopnovaes5 years agoHelper I
Yeah! Different goals products for different channels.
I can do this by conditional column, for each goal product sold the power query writes typeid in a column created, in pbi I use the filter tool for these types and I can already list all customers who have already reached total, partial and zero goal . I was wondering how many customers were served partially or completely and how many times the salesperson completed the goal.