Hi All. I'm trying to create a summary sales saved search, but running into problems. I basically want to show sales by location on sales orders. So i'm pulling in all line items for sales orders and mainline = false. What want to do is to group by the main location (location in the mainline transaction of a sales order). is there a way to source that location from the mainline trans onto the line items (i've tried multiple ways with no luck? any ideas on how to get this search to access the main location would be appreciated. thx

If you use main line is false is not possible Location header is not equal to location line ?