Hi,
I have two tables, one with sales and all the related columns with sales definitions and other table with expenses for each comercial.
I want to sum the sales margin and deduct the expenses per comercial, keeping the visual ou page filters in table one as It must be analyzed not only by salesman, but also by the warehouse unit where the comercial is based, by business, by date and sales types (sales with or without comissions), other...
Table sales and table expenses are linked through a concanetad column year,month,day,salesman - all present in expenses table and unique
Below a small example of it:
Table one (sales) (we have more than 50 salesman that make at least 10 sales per day, therefore the salestable is huge...)
Warehouse unit | salesman | year | month | day | margin | type of sale | order or sale | ......
Unit 1 | 001 |2024 | 01 |25 | 100 | goods | Sale |....
Unit 2 | 95 | 2024 | 01 |20 | 50 | goods | Sale |....
Unit 1 | 005 |2024 | 02 |5 | 100 | goods |order |....
Unit 1 | 001 |2024 | 01 |25 | 100 | goods |order |....
Unit 2 | 95 | 2024 | 01 |20 | 150 | comission | Sale |....
I have two tables, one with sales and all the related columns with sales definitions and other table with expenses for each comercial.
I want to sum the sales margin and deduct the expenses per comercial, keeping the visual ou page filters in table one as It must be analyzed not only by salesman, but also by the warehouse unit where the comercial is based, by business, by date and sales types (sales with or without comissions), other...
Table sales and table expenses are linked through a concanetad column year,month,day,salesman - all present in expenses table and unique
Below a small example of it:
Table two (expenses)
salesman | year | month | day |
001 |2024 | 01 |5 | 10
95 | 2024 | 01 |20 | 5
005 |2024 | 02 |5 | 15
001 |2024 | 01 |20 | 10
95 | 2024 | 01 |12 | 100
Please help
