topic Re: No of Unit for the top product (based on sale amount) in App Development

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

yipchunyu — Wed, 11 Mar 2020 07:08:46 GMT

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?

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

Anil_Babu_Samineni — Wed, 11 Mar 2020 07:15:31 GMT

Perhaps this?

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

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

yipchunyu — Wed, 11 Mar 2020 09:01:26 GMT

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)

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

tresB — Wed, 11 Mar 2020 09:41:20 GMT

Try like:

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

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

yipchunyu — Wed, 11 Mar 2020 09:51:36 GMT

It works well. Great thx.