Table to show product with max sales

[Georgy_Paul]

Hi,

Is it possible to create a table with country as row and corresponding product name with max sales. In a nutshell, is it possible for the measure to show a text ?

[tresB · Accepted solution]

YES. Try like:

Dimension : Country

Exp : FirstSortedValue(Product,  -Aggr(Sum(Sales), Country, Product))

[Georgy_Paul]

Thanks !