How to Use AGGR functon

[himabinduch]

Hi All,

i have three fields as below

product name, sale, profit

now i would like to show the top 10 product name and sales based on Profit.

(here i should sort the product names based on profit but should display sum(sales))

[Anonymous]

=if(

Aggr(Rank(Sum(Profit)), product name)<=10,

product name,

'Others'

)

[Anonymous]

Or following?

Dual(Aggr(Rank(Sum(Profit)), Country)<=10, product name,’’),Sum(Sales))

[sumeet-vaidya]

Hi Hima,

Please use below Calculated Dimension & Expression.

Calculated Dimension:

=if(aggr(rank(sum(Profit)),Product)<=10,Product)

Expression :

Sum(Sales)

Regards

Sumeet