I am trying to define the colors of states on a map based on two fields. The first is the total sales for each state, where I want states to be shaded light to dark. The second is whether the state has more domestic sales or foreign sales (domestic + foreign = total sales). If the state had more domestic sales it should be pink. If it had more foreign sales it should be teal. For example, Texas had high total sales but more foreign than domestic so it should be dark teal. Oregon had low total sales but had more domestic than foreign so it should be light pink.

The problem is that I can’t drag both fields onto Color. If I drag one on, then the other, the second one replaces the first. If I ctrl+click both fields and try to drag them on together, only one is applied.

My domestic vs foreign color field is a calculated field based on two other calculated fields. First, Total Domestic Sales is defined as follows:

It is similar for the Total Foreign Sales field. Here is the Domestic vs Foreign Sales Rank field that determines color:

Everywhere I’ve searched, I’ve seen examples where you can put two fields onto Color, so I’m not sure why I can’t do that in this case.