RE: How do I summarize data in a saved search?
Currently my saved search returns all purchase order line items.
I want to return only one purchase order per line on the saved search (grouping the line items together to summarize the data).
I tried to do this by putting the Summary Type for the Purchase Order column to be “Group”, but this only returned the Purchase Order Numbers and not the rest of the information I need.
Anyone know how to do this? I appreciate your help!
If you don’t want the data from the various line item fields to appear at all, then you need to add filtering to get rid of them properly, such as adding Main Line = True.
If you want to group the lines, then you need an operation for every column you want to see. For example, it you are returning, from each line item, the fields Item, Quantity and Amount, then how do you want to group these, since all lines have different values? Once you have have figured out what you want to do, select the proper operator on each line.