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



      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.