help in set analysis

[ali_hijazi]

Hello got the following sample data:

TPK, Date, Metric

A, 7/6/2015, 9

A,8/6/2015, 15

B,5/5/2015, 10

B, 6/5/2015, 7

now the user selects the months May and June

what I want to display in a pivot table (dimension = TPK) for A, 15 and for B, 7

i.e. the metric that corresponds to the latest date for each TPK in the selection

[sunny_talwar · Accepted solution]

Try this expression:

=FirstSortedValue(Metric, -Date)

[sunny_talwar]

This:

[Anonymous]

do you have master calendar?

If yes why don't you try with Max(Date)?

[ali_hijazi]

yeah

I forgot about this function