can someone assist me with a query to display total sales quantity for two whses on two different columns for a specified range of dates. Basically what i want to achieve is:
Whse code 1 Total quantity sold [column]
Whse code 2 Total quantity sold [column]
if someone has such a query please assist me with it.