Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Could it be that there are multiple names with the same 10th value (36)?