In the application overview, click on the button in the top right-hand corner in order to create a new sheet and then click on the Create new sheet button. Name this sheet Relationships.
Once inside the newly created sheet, go to the Charts asset pane and double-click on the Scatter plot chart button.
Add the following measure (m) and dimension (d) in exactly the same order as shown here:
(m) Sum(Sales) (m) Sum([Sales Qty]) (m) Sum(Margin) (d) Product Sub Group
In the properties pane, under Appearance | Colors and legend, switch off the Auto colors. Then select By expression from the drop-down menu.
Finally, add the following expression to the area provided below the drop-down menu:
