I want create saved search for below Top-Selling Products (by Qty and Revenue) Top-Selling Products (by Qty and Revenue) Helps with forecasting and inventory planning. Group by: Item Columns: Quantity Sold, Total Revenue, Avg Price

AI generated answer (using internal Slack threads):

To create a saved search for top-selling products by quantity and revenue, you can follow these steps: 1. Navigate to Reports > Saved Searches > All Saved Searches > New. 2. Select the "Transaction" record type. 3. In the "Criteria" tab, add the following filters: - Type: Sales Order - Main Line: No (this will ensure you're looking at line items, not the entire order) - Date: set the range you're interested in. 4. In the "Results" tab, add the following fields: - Item (Group) - Quantity (Sum) - Amount (Sum) 5. To calculate the average price, you can use a Formula (Numeric) field with the formula

{amount}/{quantity}

. This will divide the total revenue by the total quantity for each item. 6. Save and run the search. This will give you a list of items sold within the specified date range, along with the total quantity sold, total revenue, and average price for each item. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******