
Step 1:
Double Click [State] to create a map. Double click [City]

Step 2:
Right click [Sales] and create a calculated field. You will need a duplicate of your measure in order to show both types of map.

Step 3:
Drag the new calculated field to color, and size.

Step 4:
Hold the control button down to copy the latitude pill. This will give you a dual axis map.

Step 5:
On one of your axis, remove [city], and change the mark type to filled map.

Step 6:
Replace the new calculated field with sum of sales on size and color.

Step 7:
Click the dropdown on the second latitude pill and select “Dual Axis”
