Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get the 6th element from a RSUM value column

FredericoSBMar 11 2014 — edited Mar 11 2014

Hello everyone,

I'm using Oracle Business Intelligence 11.1.1.7.131017 .

I have a column with the following formula: RSUM("Tickets"."Number of Tickets") but since we only want to show the values associated with the last 6 months and that is a accumulative column, we added the rank function in the filter and placed as: Rank ( RSUM("Tickets"."Number of Tickets")) <= 6 and for the final formula we need the minimum value which is placed at the 6th position..

My problem is how can i get the value placed at that position ?

Here's the column values:

30719 (value that i pretend -> min )

31357

32025

32595

33652

34616 (i also use this value -> max)

Any idea on how can i get the value placed at rank 6  ?

Thanks for the help and have a good week.

Regards,

Frederico.
This post has been answered by FredericoSB on Mar 11 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 8 2014
Added on Mar 11 2014
#11g, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #help
15 comments
315 views