There is a saved search to show the total sales amount for each customer, need a formula to show the items for the total amount on one row not multiple rows

AI generated answer (using internal Slack threads):

Based on the conversations, it seems like you want to create a saved search that shows the total sales amount for each customer and the items contributing to that total amount on a single row. Unfortunately, NetSuite saved searches do not support this functionality directly. However, you can achieve this by creating a saved search that groups by customer and item, then summing the amount. This will give you a list of customers and the items they purchased with the total amount for each item. Here's a basic example of how you could set up this saved search: 1. Go to Reports > New Search 2. Select Transaction as the record type 3. On the Criteria subtab, add the following filters: - Type = Sales Order - Main Line = False (this will exclude lines that are not item lines) 4. On the Results subtab, add the following fields: - Group: Name (this will group the results by customer) - Group: Item (this will group the results by item within each customer) - Sum: Amount (this will sum the amount for each item within each customer) This will give you a list of customers, the items they purchased, and the total amount for each item. However, each item will still be on a separate row. To get all the items and their total amounts on a single row for each customer, you would need to export the search results and use a tool like Excel to concatenate the item and amount fields into a single cell for each customer. Please note that this approach may not be suitable if customers have purchased a large number of different items, as the concatenated list could become very long. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******