Derive a Dimension on Selected Date Range ,Or Calendar(Year,Month,Quarter)

[gauravgg]

Hi All

I the following table

ID	Date	PaymentTerms
1	01/01/2017	FOR
1	02/03/2107	Exworks
2	03/05/2017	Exworks
2	05/10/2017	FOR
3	04/09/2017	Exworks
4	06/06/2017	FOR

on selection of date range

I want PaymentTerm by ID by Max Date

This calculation should be done on fly (in presentation layer)

Want to use it as dimension

Thanks in advance

[sunny_talwar]

May be like this

FirstSortedValue({<Date = {"$(='<=' & Date(Max(Date)))"}>}PaymentTerms, -Date)