1 of 1 people found this helpful
Would you have a small packaged workbook to share with the community - Packaged workbooks and flows: when, why, how
In general, I think the solution here is to utilize Level of Detail calculations - Overview: Level of Detail Expressions - Tableau
Best of luck
This can be done as a dual axis chart, but it would be best if you could share the sample data source that you are showing above and possibly your twbx file.
Since you want to use Share Price as a dimension and GS price as a dimension first thing I'd look at would be to pivot (aka unpivot/transpose) those two columns. This is because of a basic guideline in Tableau - if we want to use a field as a dimension then it should be generating rows, and in this case we want to use two dimensions as if they are one dimension.
Then you'd have a new pivot field values column with all the values of price and a pivot field names column for Share Price or GS Price. The value could be on Columns and then you'd use a dual axis for the two measures on Rows. Depending on how your data is set up there might need to be a little extra work with filters or calculations to ensure that the measures on Rows aren't duplicated.
(FYI a couple of years ago Tableau announced that they were working on layering in visualizations so we wouldn't have to do the pivot or other data prep for situations like this, we haven't gotten there yet.)