Display selected values of a field and lump other values into the Others column

[#1]

Hello everyone,

I am having a chart like below

I would want to do a chart where I want the user to select 5 currencies and display the 5 currencies and lump all the other currencies into the 'others' category. So the dimension has to be dynamic. I have struggled to do this and would like to know if someone can help me with this.

Thanks in advance,

Sri