Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have below fields
LogTable:
customer.number
issue.comment
issue.comment.date
issue.comment.number
NOTE: In the above table customer can have multiple comments on same date. The highest comment.number indicates the latest comments not the date.
CustomerTable:
customer.name
How can i create straight table that shows customer name, last comment date & last comment
In order to do the above. I have to setanalysis like below
show issue.comment for the last max issue.comment.number.
customer name | customer number | last issue.comment.date | last.issue.comment (based on max(issue.comment.number)
Look into FirstSortedValue() function:
With dimension customer.name, try these expressions:
=FirstSortedValue(issue.comment, -issue.comment.number)
=FirstSortedValue(issue.comment.date, -issue.comment.number)
(or just max(issue.comment.date) for the last one)
Hope this helps,
Stefan
