No of Unit for the top product (based on sale amount)

[yipchunyu]

I am working on a new dashboard with KPIs

It will included:
1. Top selling product's sale amount
=Max(Aggr(Sum(Amount), Product_Name))

2. The selling product name 

=FirstSortedValue(Product_Name, -Aggr(Sum(Amount), Product_Name))

But how can I get the sum(no of unit) for this product?  

[Anil_Babu_Samineni]

Perhaps this?

Sum({<Product_Name = {"=FirstSortedValue(Chr(39) & Product_Name & Chr(39), -Aggr(Sum(Amount), Product_Name))"}>} [No Of Unit])

[yipchunyu]

I tried it by substitute with my field names but it returns 0 all the time.  Anything I did wrong?

=Sum({<PD_Product_Name = {"=FirstSortedValue(Chr(39) & PD_Product_Name & Chr(39), -Aggr(Sum(ANP_USD), PD_Product_Name))"}>} CASE_COUNT)

[tresesco · Accepted solution]

Try like:

=Sum({<PD_Product_Name = {'$(=FirstSortedValue( PD_Product_Name , -Aggr(Sum(ANP_USD), PD_Product_Name)))'}>} CASE_COUNT)

[yipchunyu]

It works well.  Great thx.