Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I've this requirement where i had to display dimension as measure where as in measure has only string values. Since it has string values i can't use any aggr functions like sum, count etc. So i used maxstring function but the problem is when a record has multiple values it's only displaying the max string value because that's how this function work. So can some help me here on how to use proper expression to display all possible value. Below is the formula that I've used. My ordername has only string values.
=maxstring({<Category={"A"}>}OrderName)