Need to get last two meeting dates

building reports webintelligence
1

I have report containing the following columns: Case Number, Name, Meeting Date.

I need to show only the last two meetings for each case number. I can get the last metting date using =Max([Meeting Date]) In ([Case Number]).

However I cannot get the previous meeting date. I have tried creating a measure for meeting date and ranking on that but it does not work.

Any suggestions would be appreciated.

stpete (BOB member since 2009-09-10)

2

I tried this in XI 3.1. Create following Measures:


[Max Meeting Date] =Max([Meeting Date]) In ([Case Number])

[Value before Max] = Max(if([Meeting Date]=[Max Meeting Date];Previous([Meeting Date]))) in([Case Number])

[Date Flag] = if([Meeting Date]=[Max Meeting Date] or [Meeting Date]=[Value before Max];1;0)

Then add a report filter to the table where Date Flag = 1

jbarnes794 :us: (BOB member since 2008-06-13)

3

Thanks

That works fine.

stpete (BOB member since 2009-09-10)