This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

How can i make a saved search that gives total amount($) of sales per customer

Sum the amount field by the grouped customer field (on a transaction search)

Make sure the Type on Criteria is set as Mainline True and the Type is Sales Order

If you're not using SO's then Invoice as the Type instead

Regarding the first column in results .. shall i remove it .. it seems that when i group by name .. it gives few more results

when i only use group by customer:Email it gives few less results

I want unique customers along with their amount ..