set analysis

[userid128223]

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

customer.number

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)

[swuehl]

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