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

    Top 10 and other

    Tim Mullady

      Hello,

       

      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,

       

      Thanks,

       

      Tim