write a set analysis tohighest all the product whose sales value is maximim

[shivika123]

Suppose I have a table

product sales 

a        30

b   30

c  10

d  5

need to write set analysis to get a and b value in a text box because it has maximum sales value.

[rahulpawarb]

May be this..

//Define a variable - eMaxSales

=Max(Sales)

//Text  box expression

Concat({<Product={"=Sum(Sales) = $(eMaxSales)"}>}Product, Chr(10))

- Rahul

[HirisH_V7]

=Concat({<ID = {"=Rank(Sum(Sales))=1"}>} DISTINCT ID,', ')

Usethis

[tresesco]

=Concat(DISTINCT {<Product={"=Rank(Sum(Sales))=1"}>} Product, ',')

[shivika123]

returning no value

[shivika123]

returning blank

[shivika123]

returning blank value

[tresesco]

Could you share your sample app to check?