get the max date PRIOR TO THE MONTH IN DIMENSION

[ali_hijazi]

Hello

I got a pivot table by Month_Year, and Customer

what I want is next to April 2016 I want to display THE MAXIMUM DATE OF THE CUSTOMER PRIOR TO APRIL 2016

and next to May April 2016 THE MAXIMUM DATE OF THE CUSTOMER PRIOR TO MAY 2016

how can I accomplish this

please advise

[adamdavi3s]

Can you add some sort of a 'sort' column mapped to your month_year then use set to just bring in max where sort=(sort-1)

[Chanty4u]

try

FristSortedValue(Customer,-Datefield)

[ali_hijazi]

I want the date not the customer

and date prior to the value of date in the dimension