show only values corresponding to the last date as dimension

[yacine]

i have a data with reference number [Nr] and date [createdat.autoCalender.date] .  In the chart, i want to show only the reference numbers which have the last date. 

Firstsortedvalue gives back error because of the result being more than one value. i tried 

=if([createdat.autoCalender.date] = date(max([createdat.autoCalender.date] ), Nr)

and if([createdat.autoCalender.date] = firstsortedvalue([createdat.autoCalender.date], - [createdat.autoCalender.date]), Nr)

both don't give back the wished result. I still get Nr of all the dates.

Is there another solution? thank you in advance.

[hic]

Use set analysis in your measure. One of the following should do the trick:

{<Nr={"=createdat = max(total createdat)"}>}

{<Nr={"=[createdat.autoCalender.date] = max(total [createdat.autoCalender.date])"}>}