Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
try
FristSortedValue(Customer,-Datefield)
I want the date not the customer
and date prior to the value of date in the dimension