I have 2 tables which should be interpreted (table export is attached):
A order will be put in table wccrm_orders + in wccrm_prov (there it can be twice, if the sales_person and the account_person are not the same
1) I need to know how many revenue I have made per month (both tables, no duplicates, and only each dress one time)
2) I need to know how many tries (wccrm_anprobe -> uid) per month combined with sales (per month)
3) I need to know how many revenue I have made per year (wccrm_orders, wccrm_prov).
I will attach the file which I have now, but the calculations are not correct. You will see in the results. I have a problem with double entries (if sales_agent and account_agent are not the same) or when a dress is not in wccrm_orders, but in wccrm_prov.
30 freelancers are bidding on average €144 for this job
Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. So I think I can help you if you want. Thank you. Best Regards.
Hello, Please message me so we can discuss on that. Please view the profile to see more works of mine. Let's discuss so I can provide you more details about me. Waiting for Your Reply soon. Regards, Ramin