Forum Discussion
Dsitribute time spent based on categories
So I have a table that is structured as follows : Customer Category Time Summary Cust A Cat1 3 Something Cust B Cat2 1 Something Cust A Cat 2 2 Something All Cust Cat1...
Hi, So it isn't exactly what I need, what I want is for the "All Cust" time to be distributed to the SUM of time of EACH other customer based on the category so that at the end I have something like this :
All Cust Cat1 Time = 2
ALL CustA Cat1 time = 3+((All Cust Cat1 Time)/(Number Of Cust)) which here = 3+1 = 4
ALL CustB Cat1 time = 0+((All Cust Cat1 Time)/(Number Of Cust)) which here = 0+1 = 1
ALL CustB Cat2 time = 1+((All Cust Cat2 Time)/(Number Of Cust)) which here = 1+0 = 0
Still searching for a way to do it ... I've found a way to sum it and distribute it WITHOUT keeping the category or to sum the category but WITHOUT being able to distribute it ...