Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can i write the expression to get the highest selling product in a text box.
Fields available:
Product Name, Sales
Try this
=FirstSortedValue(Product,aggr(sum(Sales),Product))
Try this
=FirstSortedValue(Product,-aggr(sum(Sales),Product))
Can you provide sample data set and explain little more?