As we are looking for line item related data, in this case a SKU, the "Product Performance" report will be a good place to start.
1. Set the
Date picker to the desired time period. For instance, YTD.
2. Set the
sku filter to the desired SKU.
order_type filter is not enabled by default. (CSA will need to surface this option).
If you like to see some visualizations, we can add or replace the existing charts for you.