Regarding the ranking

building reports webintelligence
1

Hi
Bo gurus

i have thwe following scenarion in my report

case id version
1 1
1 2
1 3

2 1
2 2

3 1

over period of time (i have time filter which tells the start and end date )

wat i need is i need only the max version for that case id to be displayed in the report as follows
case id version
1 3
2 2
3 1

how can i acheive this in WEBI boxir2 i tried to use rank function but its not giving the results wat i want

can any body help me

thanks
pavan :nonod:

dpavank2007 (BOB member since 2007-05-24)

2

You could probably do a filter based on a variable that tests for the maximum value… something like:

=if(version=(max(version) foreach (caseid));1;0)

then filter on just 1…

Not sure of this would work…but worth a try…

mjyoungman :australia: (BOB member since 2006-10-06)