Need to create a report for units sold and total quantity on hand by location. Please advise what is the best way to do it because I tried but cannot get it by location only the total units by all location.

Thanks.