V
Vic
Hello,
I have a table Customers with turnover and category. I need a query that
calculate how many percent the turnover of each customers represent in the
total turnover of the category to which the customer belong and in the total
of all customers. Example I have 3 customers, Cust1_Cat1_Turnover 10?, Cust2
_Cat1_Turnover 40?, Cust3_Cat2_Turnover 50? Then the turnover of Cust1
represent 20% of Cat1 and 10% of total sales, Cust2 = 80% of Cat1 and 40% of
total and Cust3 = 100% of Cat2 and 50% of total sales. I hope this is a bit
clear, and somebody can help me with this.
Best regards, Vic
I have a table Customers with turnover and category. I need a query that
calculate how many percent the turnover of each customers represent in the
total turnover of the category to which the customer belong and in the total
of all customers. Example I have 3 customers, Cust1_Cat1_Turnover 10?, Cust2
_Cat1_Turnover 40?, Cust3_Cat2_Turnover 50? Then the turnover of Cust1
represent 20% of Cat1 and 10% of total sales, Cust2 = 80% of Cat1 and 40% of
total and Cust3 = 100% of Cat2 and 50% of total sales. I hope this is a bit
clear, and somebody can help me with this.
Best regards, Vic