Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
there is a situation I never experienced before,
There is a customer, its value and its Sold Date, for each customer I have to find the values corresponding to max date.
I Always solved the problem in the script (in a very sinple way), now I am trying to write an expression to solve the question in the front end, I nearly did it but there is still a field I do not want to see. Is it possible to achive the result without including DateSold field as dimension? I do not want to hide the field, I do not want to include it!
Refer to the attached qvw.
Thanks
Try FirstSortedValue(Value, -DateSold)
Try FirstSortedValue(Value, -DateSold)
Great!