Calculating Weighted Sales
I need help in calculating weighted sales. Context: There are two tables; Sales transaction and Sales Weights tables (examples attached with dummy data). Sales is divided into direct and indirect sales. If it is indirect sales is alocated to sales rep. who is covering that specific customer. On the other side if sales is direct, then sales amount should be splitted to sales reps by weights given in Sales Weights table. Relationship between tables: In order to create relationship between two tables, bridge table is created with unique code created by merging category and customer code. How to create formula that will calculate weighted sales for direct sales for each sales rep per customer per category? Some switch formula Thanks Bridge table Sales table Weights table
