vtleogal2

Help getting last 5 status reports per project in Webi

Discussion created by vtleogal2 on May 6, 2013
Latest reply on May 16, 2013 by vtleogal2
Hi,

In Webi, I'd like to get the last 5 status reports (going by report date) per project. So it would look something like
project id status report date
12345 5/1/13
12345 4/25/13
12345 4/18/13
12345 4/12/13
12345 4/1/13
77777 5/1/13
77777 4/25/13
77777 4/18/13
77777 4/12/13
77777 4/1/13

I've tried different functions can't seem to get it just right. Does anyone know how to do this in Webi? The project could have many reports, such as 20, but we only want to show to the top 5.
BO XI 3.1
Clarity v 12.1
Oracle

Thanks
Lynn

Outcomes