I have a lot of duplicate lines in my sales value, these lines are the result of a large query breakdown with sublevels. But now I need to calculate the sum of sales by ordernumber and itemnumber, so my output for pepsi would be 18 and for coca cola would be 24.
What is the best solution for this? (see picture below)
example
New contributor
mvisser is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.