2 of 2 people found this helpful
If all titles are the same you could reach your first option based on a union
If all titles must be maintained "as is" you could reach your second option based on a union.
A union in Tableau is explained here
You can pivot both tables only if you can join them by common key. If it is not a big deal, can you add a common key to both tables then join them on that key and then pivot both tables and then you can get what you want.
I agree with Norbert that a union is going to give you what you need. You may initially end up with a table that has all the rows of Table 1 and Table 2 instead of aggregated rows of Table 1 with rows of Table 2. But this should be fine because you can use aggregation in the Tableau viz to sum together all the 1 values to get the quantity.
You might find a calculation like this
ZN(Sale) + ZN(QTY)
helpful to combine the Sale and QTY fields. Then treating that as a measure (specifically a SUM) in your view will give you correct results.
Hope that helps!
Thank you all for your response. I'm still working on it and made some progress, but I see where you are all going with this.