Aggr & Rank

[MK_QSL]

What is wrong in below code... My idea is to get TOTAL QTY for TOP 10 Customer...but I am not getting any result

=SUM(IF(AGGR(RANK(SUM([Inv QTY])),[Customer Name])<=10,SUM([Inv QTY])))

[v_iyyappan]

Hi,

you and my expression same. only difference is like

1	Lowest rank on all rows.
2	Average rank on all rows.
3	Highest rank on all rows.
4	Lowest rank on first row, then incremented by one for each row.

Please check it.

regards,