Display values from 2 items in a single line
I have a custom filed for replacement item number. So part x is sold out but part y is the replacement. I also have a field for quantity sold this year. In a search, I can get
Part x name, quantity sold this year, replacement.
What I really need to know is the quantity sold of part y on the same line so I can see the main parts qty sold and the replacement part qty sold. so something like this in the results:
name, qty sold, replacement, replacement qty sold