Rank function for top 15 sales

[#1]

Hi,

can any body give expression to find the top 10 sales of country.

dimensions are country and customer for grouping.tell me how rank function is advantage over dimension limit property.

regards

Mahesh

[Sokkorn]

Hi Mahesh,

Here is sample one: Sum({$<Country = {"=Rank(Aggr(Sum(Sales),Country))<= 10"}>} Sales)

Regards,

Sokkorn

[#3]

i am expecting answer with out set analysis.

regards

Mahesh

[Sokkorn]

Or you can play around with attached file.

Regards,

Sokkorn

[Sokkorn]

Maybe this one: Sum(If(Aggr(Rank(Sale),Country)<=15,Sale))

Regards,

Sokkorn

[#6]

can u pls resend the attached file

[#7]

PFA

[Sokkorn]

Here you are

[#9]

Try This dude,

=If(Aggr(Rank(Sum(Sales)),Customer,Country)<=10,Sum(Sales))

You can change the grouping order as per the requirement.