Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
YES. Try like:
Dimension : Country
Exp : FirstSortedValue(Product, -Aggr(Sum(Sales), Country, Product))
YES. Try like:
Dimension : Country
Exp : FirstSortedValue(Product, -Aggr(Sum(Sales), Country, Product))
Thanks !