I'm tryng to create a table that shows the top 10 Regions in a table and then groups all the other Regions into Other. This is based on Revenue
Is there a way to create a calculated field to do this?
I'm thinking that combining an If statement with a ranking function may be able to accomplish this.
Any help would be appreciated,