I need to display dimension based on Max(Sales), want to display product which has Max(Sales) in a straight table.
Any help on how to achieve this.
If Expression - FirstSortedValue(Sales, -Aggr(Sum(Sales), Dimension))
If Dimension - If(Sales=Max(TOTAL Sales), Dimension)
Hi, please try this set expression : =Max(Aggr(Sum(Sales),Month))
and Dimension must be Product