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?
