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])))
you and my expression same. only difference is like
Lowest rank on first row, then incremented by one for each row.
Please check it.