I am trying to create a saved search that shows the total sales and costs of a project. I can get it to return the correct numbers, but it returns the SO total for each line item. I can't figure out how to have it return just one line for the total of the SO.
Here is the total of the project with this SO for reference
I have tried different fields and different arrangements of the columns, but no luck. If anybody has any ideas, please send them my way. Thanks!