RE: 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
If you have a unique value between two records then you can group, write CASE STATEMENT, sum up, and have a different column on the same line.
