set analysis

[thanhphongle]

Hello community

this is my table

Category	Sales	Rent
Car	1.000.000	15.000
Motorbike	800.000	14.500
Truck	750.000	17.000

I wanna create a text object which returns me the rent from the biggest category referring to sales

Example:

Biggest Category from Sales = Car with 1.000.000

QV should return me 15.000

I tried this expression:

=Max(TOTAL Aggr(Sum(Sales), Category))

QV returns me 17.000

Can anyone help me out here?

[tresB]

Try :

FirstSortedValue( Rent, - Sales)

[swuehl · Accepted solution]

Maybe like

Sum({<Category = {"=Rank(Sum(Sales))=1"}>} Rent)

[thanhphongle]

works good! thank you