I have multiple tables of sales data orgainzed by sales channel. For each row of data, there are over 70 fields with either categorization of the products or data related to the sale - volume, revenue, ad spend, commissions, etc....
Here is my challenge boiled down to two of the tables for example.
Table a is ALL SALES
Table b is RETAIL SALES
How do I generate WHOLESALE SALES given that ALL SALES-RETAIL SALES = WHOLESALE SALES? I've tried the related functions, but I'm obviously doing a lot of something wrong!!
Here is my challenge boiled down to two of the tables for example.
Table a is ALL SALES
Table b is RETAIL SALES
How do I generate WHOLESALE SALES given that ALL SALES-RETAIL SALES = WHOLESALE SALES? I've tried the related functions, but I'm obviously doing a lot of something wrong!!
