'Combining string and integer conditions with tableau calculations

Here’s the gist of my problem:

I have two sets of data that contain a current and legacy product. In each case, the sizes and type match. For example, the legacy is called P 125 and the new generation Q 125. I essentially need to match each value to say, if there’s a QTY balance for P 125 and Q 125 then line the values up and show their individual QTYs. Right now, I’ve pulled in the data but it puts all of the legacy units/qtys first and then the new generation. These need to be side by side and match. Any thoughts on how to do this are appreciated!



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source