Hi all,
I am trying to make a GI to show the top 100 customers by sales numbers. I think the easiest way to do this is to modify the Sales Profitability Analysis Detailed report to make it summarized.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/492b76ff-e46c-457e-9b10-e7d7952a405c.png)
For example, I would like to add all of the line items for the same customers together to get a net sale number for the customer, and only show each customer once. How would I go about doing this?
Thanks all for the help!