Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to write the expression for Sum of Top 5 order value by orderID in Text object
May be like this:
Sum({<OrderID = {"=Rank(Sum([OrderValue])) <= 5"}>}OrderValue)
=sum({<OrderID ={"=rank(sum(OrderValue),4) <=5"}>}OrderValue)