top 1 product by quantity in a line chart

[TarekHajji]

Hello

using a line chart, i want to show the product quantity per month, just for the product has the top quantity

I used the below expression to get the top 1 product by quantity ; 

FirstSortedValue(PRODUCT_NAME, -aggr(sum(QUANTITE_REALISE), PRODUCT_NAME))

and its work correctly 

 but when i want to show this product's quantity by month in a line chart , using the bellow expression the result is 0

sum({<PRODUCT_NAME={'FirstSortedValue(PRODUCT_NAME, -aggr(sum(QUANTITE_REALISE), PRODUCT_NAME))'}>}QUANTITE_REALISE)

Any help please

Thank you

[Taoufiq_Zarra · Accepted solution]

Bonjour Tarek,

there's an error in the expression, maye be :

=sum({<PRODUCT_NAME={"$(=FirstSortedValue(PRODUCT_NAME, -aggr(sum(QUANTITE_REALISE), PRODUCT_NAME)))"} >}QUANTITE_REALISE)

[TarekHajji]

Thank you,

it's working .