Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this expression:
=FirstSortedValue(Metric, -Date)
This:
do you have master calendar?
If yes why don't you try with Max(Date)?
yeah
I forgot about this function