Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
alexandros17
Partner - Champion III
Partner - Champion III

Sum where max

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Try FirstSortedValue(Value, -DateSold)


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

Try FirstSortedValue(Value, -DateSold)


talk is cheap, supply exceeds demand
alexandros17
Partner - Champion III
Partner - Champion III
Author

Great!