Rank function Null Issue

[sat_tok52]

HI Guru's,

I am using Rank function to get Top 10 customers in pivot table , but I am getting 9 customers and 10th customer it is showing up as null.In my customer column have above 20 customers,below is the calculated dimension I am using .

Calculated Dimension:

=if(aggr(rank(Count(customer)),Name)<=$(vTop),Name)

Expression:

Count(customer)

vTop=10

Result:

Name    Count

A    13

B    12

C    11

D    11

F    9

G    8

H    7

I    6

J    5

-    36

Thanks,

Sateesh

[tresesco]

Could it be that there are multiple names with the same 10th value (36)?