1. Go to Analysis
  2. Go to information library
  3. Click Add Ad-Hoc Query
  4. Select Sales Orders in the source view, click OK
  5. Select sales order from the left-hand column and then from the middle section, drag Transaction date to 'include records where' select the date or range or dates you want to filter on
  6. From the left-hand column select Sales Order Item, from the middle column drag Type to 'include records where' set it equal to Merchandise
  7. From the left-hand column Expand Sales Order Item, Expand Sales Order Item Merchandise, select vendor. Then from the middle column Select  Merchandise Vendor records  and drag it to 'include records where' using the click the magnifying glass and search for the Vendor's record. 
  8. Or to look for department- From the left-hand column Expand Sales Order Item, Expand Sales Order Item Merchandise, select department. Then from the middle column Select  Merchandise Department records  and drag it to 'include records where' using the click the magnifying glass and search for the department's record. 
  9. Or to look for Category- From the left-hand column Expand Sales Order Item, Expand Sales Order Item Merchandise, Select category. Then from the middle column Select  Merchandise category records  and drag it to 'include records where' using the click the magnifying glass and search for the category's record. 
  10. To include item details- From the left-hand column expand sales order item, expand sales order item merchandise, select inventory item and from the middle column select item details and move to results fields to display
  11. To include SKU-  From the left-hand column expand sales order item, expand sales order item merchandise, select inventory item and from the middle column select SKU and move to results fields to display
  12. To include the number of item sold in the order sales order- From the left-hand column select sales order item and then from the middle column move quantity to results to display.