Displaying 1 result from an estimated 1 matches for "managers_abc".
2017 Sep 08
0
need help for finding related sales with R
...ot a dataset that contains next information:
Sales_department; sales_manager; Client; transaction ID; Product (SKU),
Cost, Gross income, Profitability
Ineed to perfom an ABC analysis (by the Cost of sold products to this
client) to find the A clients of each manager, i'm doing it this way:
managers_ABC <- svod %>%
group_by(Sales_department, sales_manager, Client) %>%
summarise("Clients_cost" = sum(Cost,na.rm = TRUE)) %>%
arrange(sales_manager, desc(Clients_cost)) %>%
group_by(sales_manager) %>%
mutate("total_sales_of_a_manager" = sum(Clients_cost),...