3 Replies Latest reply: Jun 17, 2015 8:45 AM by Sunny Talwar RSS

    which performance is better while excluding values in set analysis?

      I have below data


      LOAD * INLINE [

          Country, Points

          India, 10

          India, 11

          UK, 12

          UK, 9

          USA, 10

          USA, 89



      I want to aggregate points for all countries except India:

      Dimension: Country

      Exp1: sum({Country-={'India'} Points)

      Exp2: sum({Country={*}-{'India'} Points)


      If we many columns in a table and using Exp1 and Exp2 methods to exclude any value, which method performs better than that of other. Is it Exp1 or Exp2 method?