Task: Tell me the total spend on products in the most recent cancelled orders of the customer who has the most cancellations in the history
Site: shopping_admin

1. Click the "Sales" tab from the left sidebar to open the dropdown menu.
2. From the dropdown, click on the first option "Orders".
3. Click the gray "Filters" button at the top right.
4. Click the down arrow for the "Status" dropdown menu.
5. Click on the option "Canceled" from the dropdown.
6. Click the gray "Apply Filters" button to execute the search
7. Click the top of the fourth column "Purchase Date" to sort the entries from oldest to most recent.
8. Scroll down so all cancelled orders are shown, then scroll upwards to the row for the most recent cancelled order from the customer who has the most cancellations.
9. Given the information, state the total spend on products in the most recent cancelled orders of the customer who has the most cancellations in the history.

1. Click the "Sales" tab from the left gray sidebar.
2. Click the button called "Orders" in the pop-up.
3. Click the gray "Filters" button at the top right of the screen.
4. Click the down arrow for the "Status" dropdown menu.
5. Click on the option "Canceled" from the dropdown.
6. Click the gray "Apply Filters" button to execute the search.
7. Click on the "Bill to Name" column in the table to group by name.
8. Scroll down so all cancelled orders are shown along with the customer names.
9. Sum up the values under the "Grand Total (Purchased)" column on the table where the customer name is the name of the person with the most cancellations, Samantha Jones.

1. Click "Sales" in the sidebar on the far left. It has an icon that looks like money symbol.
2. Click on "Orders" within the Sales tab on the sidebar.
3. Click the "Filters" button on the Orders page. The button is to the right of the search bar.
4. Click on the "Status" field in the Filters tab.
5. Click on "Canceled" in the Status filter field dropdown.
6. Click on "Apply Filters" at the bottom of the filters tab. Ensure that the only filter applied is the canceled status filter before applying the filters.
7. Scroll through the entire orders table. Ensure that the table is sorted in descending order by "Purchase Date" (indicated by the downward facing arrow in the "Purchase Date" column header). Identify the frequency of the customer names that occur in the "Bill-to Name" column.
8. Scroll up to the most recent order (the order closest the tbhe bottom of the table) by the customer who has the most cancellations. In this case the customer is "Samantha Jones".
9. Click on the row with the order by the customer we identified.
10. Scroll down to the "Order Totals" section of the page. Identify the "Total Due".

1. Click "Sales" in the left sidebar
2. Click the "Orders" button in the popover options
3. Clear any existing filters if an "x" is visible under "Search by keyword"
4. Click the "Filters" button on the right side of the screen
5. Click on the "Status" dropdown
6. Click on "Canceled" in the dropdown
7. Click "Apply Filters"
8. Scroll down and count who (in "Bill-to Name") has the most cancelations by number and note their name
9. Scroll down again and add up the price of all "Canceled" orders with that name as "Bill-to Name"

1. Click on the “SALES” button in the dark gray column on the left hand side of the page.
2. Click on “Orders” in the pop up menu, located under the heading “Sales”.
3. Click the “Filters” button, located to the left of the “Default View” button.
4. Click on the “Status” criteria box, located directly under the bolded text “Status”.
5. Click “Canceled” in the pop-up menu.
6. Click the “Apply Filters” button, located near the bottom right of the screen.
7. Scroll down through each row of the orders table, keeping track of which customer has made the most cancellations. The customer can be found in the “Bill-to Name” or “Ship-to Name” columns of a given row.
8. Identify the name of the customer with the greatest number of canceled orders.
9. Click on the “SALES” button in the dark gray column on the left hand side of the page.
10. Click on “Orders” in the pop up menu, located under the heading “Sales”.
11. Click into the search bar, located above the customers table.
12. Type in the name of the customer with the greatest number of canceled orders.
13. Press enter.
14. Click on the “Purchase Date” column header to sort the table from oldest to most recent.
15. Click again on the “Purchase Date” column header to sort the table from most recent to oldest.
16. The total spend on the most recent cancelled order by the customer with the most cancellations is in the "Grand Total (Purchased)" column of the row containing the most recent canceled order by the customer with the most canceled orders.

1. Hover over the catalog icon in the dark grey bar on the left.
2. Click "product".
3. Click into the "search by keyword" box.
4. Type "Samantha Jones".
5. Press enter.
6. Scroll until finding the most recent cancelled product.
7. Click on the product.
8. Record SKUs.