i want show in Text Object maximum product id and minimum product id using shipcost in One Text Object both Id i want to display

[Vijayqliksept12]

[jyothish8807 · Accepted solution]

Hi @Vijayqliksept12 ,

Try this:

='Min :'&FirstSortedValue(Productid,Aggr(sum(Shipid),Productid)) & ' Max :'& FirstSortedValue(Productid,-Aggr(sum(Shipid),Productid))

[Vijayqliksept12]

is there any chance use only function like =only({<Productid={'$(=max(Productid))','$(=min(Productid))'}>}shipid)

if any above statement wrong correct me

[jyothish8807]

You can try this as well:

=only({<Cost={'$(=min(Cost))'}>}Productid)
=only({<Cost={'$(=max(Cost))'}>}Productid)