Difficult to answer without seeing the structure of your data, unfortunately. I'd suggest that you try to mock up a sample data set (and workbook) with data in a similar structure as the data you're working with. Or you can check out the following for tips on how to anonymize your workbook: Anonymize your Tableau Package Data for Sharing
4 of 4 people found this helpful
I see that you uploaded a sample workbook.
I'd suggest that you start by pivoting the 3 measures (here's how: https://www.kenflerlage.com/2018/06/pivoting.html).
I then renamed Pivot Field Names to Type and Pivot Field Values to Value. It should look like this:
Now create two calculated fields. One will be just profit margin 1, which we'll use for the bar chart. The second will be all other profit margins, which will be used for the line charts.
Profit Margin 1
// Get just profit margin 1.
IF [Type]="Profit Margin 1" THEN
Profit Margin 2 & 3
// Everything except profit margin 1.
IF [Type]<>"Profit Margin 1" THEN
Next create two separate bins fields on each of these fields, drag the bins up to the columns shelf, and change them to continuous, and of course, drag SUM(Number of Records) to the rows shelf.
On the second axis, drag Type to the color card and change the mark type to line.
Finally, make it a dual axis and adjust your colors as desired.
If this helps to resolve the issue, then please be so kind as to mark this response as the "correct answer." This will close the thread and will make it easier for people to find the answer to similar questions in the future. Thanks!
Great, this works, thanks so much!!