i have order id and unit price separate columns . for each orderid i have different unit princesses, among all i want the max unitprice. can i achieve this by using rangemax ? and how ?
moreover its in chartlevel
Try like below
Dim: Order IDExp: Max(UnitPrice)
View solution in original post
Share sample with expected output