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

Rookie Asked on April 2, 2021 in Saved Searches.
Add Comment
1 Answer(s)

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.

Rookie Answered on April 5, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor