Profit report by customer and by product.
Hello, I want to know for which customer I am earning more and which product to buy
I also want to know from which project I earn the most.
the data I need are:
Date:
Customer name:
Product name:
Invoice number:
Quantity:
Total profit:

I tried to get these reports from analytics but when making dynamic tables they do not show me results.
I also tried sql but failed.
I need your help.
Thank you..