I want to auto-select a country if i selects a state , like
If i select Texas , In state list . In my country list United states have to be selected automatically .
I'm taking country & state list from excel sheets & I concatenated them both into a link ,
then i'm using subfield to save them into variables and to display them into separate lists which makes me if i select a state it auto selects country .
Until now i dont have any issues ,
I want to display sales in country if they are selecting a state , but if they selects states from different countries how can split them using a string function or anything to display sales in different countries .