This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have just seen that looked slightly incorrect with the countries.
I am wondering if its due to the key creation though. As you have India and China under the 1 key of USA, whereas maybe you wanted them to be the initial entry so the key should look like:
Note: I just updated the key field, and didn't update my formulas. If the key cannot be built like that, and in fact does have 1 at the start of the subsequent countries I'd recommend writing a conditional formula to remove them.
The switch in the formula uses Regex_CountMatches to find the number of periods "." in the key. Based on the result of this, CharfromInt returns a different character to use as the leading symbol. You can add more levels to the switch statement to add more symbols.