need to find top 25 to 50 records

[saran_gj]

I am having more than 100 records

Q1. find the top25 records?

ans. if(aggr(rank(sum(sales),country) <=25, sum(sales))

q2. find the top 25 to 50 records?

ans. need to find????? can anyone help me to solve  this...

[ggijben · Accepted solution]

Hi @saran_gj , 

Can you try:

SUM( AGGR( IF( RANK(SUM(sales)) >25 AND RANK(SUM(sales)) <=50, SUM(sales)) ,country )) 

[saran_gj]

its work. thank u genius.

[ggijben]

Glad it works! Could you mark the post as a solution, so others know it's solved?