Display selected values of a field and lump other values into the Others column
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.