3 Replies Latest reply: Nov 21, 2012 12:26 AM by Andrew11 RSS

    Showing to 5 customers: Which is better - Dimension Limits or Calculated dimensions

      HI

       

      If I want to show the top 5 customers, I can create a Calculated Dimension such as:

       

      Option 1

      = if(Aggr(rank(sum(Revenue)),Name) <= 5, Name)

       

      Option 2

      I can get the same result by simply doing a sum(Sales) and forcing it to show the top 5 under the Dimension Limits tab.

       

       

      The question is, which is more efficient / better to use on a large data set of 100m+ records.

       

      Thank you.