I recently managed to group my currency pairs in groups using the following calculated field formula
ifelse({CurrencyPair}= ‘EURAUD’, ‘Developed’,
{CurrencyPair}= ‘EURCAD’, ‘Developed’,
{CurrencyPair}= ‘EURCHF’, ‘Developed’,
{CurrencyPair}= ‘EURDKK’, ‘Developed’,
{CurrencyPair}= ‘EURGBP’, ‘Developed’,
{CurrencyPair}= ‘EURHKD’, ‘Developed’,
{CurrencyPair}= ‘EURJPY’, ‘Developed’,
{CurrencyPair}= ‘EURSGD’, ‘Developed’,
{CurrencyPair}= ‘EURUSD’, ‘Developed’,
{CurrencyPair}= ‘EURINR’, ‘Non Developed’,
{CurrencyPair}= ‘EURMXN’, ‘Non Developed’,
{CurrencyPair}= ‘EURKRW’, ‘Non Developed’,
{CurrencyPair}= ‘EURBRL’, ‘Non Developed’,
{CurrencyPair}= ‘EURTWD’, ‘Non Developed’,
{CurrencyPair}= ‘EURCNH’, ‘Non Developed’,
NULL)
so I can then create a parameter and filter by group.
Is not clear to me how to implement when the same currency pair let say EURAUD is part of multiple groups (Es. Developed and G3). so I can have more group filters some containing same values.
Any help welcome.
Thank you.