This content has been marked as final. Show 3 replies
If I want to show the top 5 customers, I can create a Calculated Dimension such as:
= if(Aggr(rank(sum(Revenue)),Name) <= 5, Name)
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.