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!

Max Date Function

590587Jun 18 2008 — edited Jun 27 2008

Hi,

I have the following columns in a report:

Vendor Name
Trade date
Prod Desc
Order Type
Qty
Gross Amt

I need to display only those rows where trade date = max(trade date).
I am aware of the MAX analytic function, but it keeps giving me an error.
Could someone please let me know how to achieve this scenario.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 25 2008

Added on Jun 18 2008

#business-intelligence-applications, #business-intelligence-foundation, #discoverer

11 comments

4,549 views