Is it possible to export the report of product sales but with the filter of order id?
Currently, I could export the product sales report by selecting the range of date, but I want to manually select the order instead.
For example:
Order ID: 1001 | Date 30/8/2024
-
Product A: 3 units
-
Product B: 2 units
Order ID: 1002 | Date 1/9/2024
-
Product B: 7 units
-
Product C: 1 units
Order ID: 1003 | Date 2/9/2024
-
Product B: 1 units
-
Product C: 1 units
What I could do now is export from 30/8/2024-2/9/2024. But I want to manually select the order; for instance, Order 1001 and Order 1003.
Expected Result
Product A: 3 units | Total: $ A
Product B: 3 units | Total: $ B
Product C: 1 units | Total: $ C
Total Sales: $ A+B+C
