1 Reply Latest reply on May 9, 2017 1:41 PM by Norbert Maijoor

    Top 10 and other

    Tim Mullady



      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,