You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI Analysis filter by max date values

Accepted answer
33
Views
9
Comments
edited Nov 5, 2019 6:45AM in Reporting and Analytics for ERP 9 comments

Summary

I want to filter a subject area, where I get only the max date, as the record is duplicated for different dates

Content

How to do below in OTBI Analysis,

 

Data Set

 

Asset_Number    Depreciation_Run_Date  Cost

--------------------    --------------------------------  ---------------

10001                  1-Jan-2019                       100

10001                   1-Feb-2019                      120

10002                   1-Dec-2018                      90

 

I want to retrieve 1 record based on max(Depreciation_Run_Date) for each Asset Number

 

The output should be as below.

 

Asset_Number    Depreciation_Run_Date  Cost

--------------------    --------------------------------  ---------------

10001                   1-Feb-2019                      120

10002                   1-Dec-2018                      90

 

 

Thanks in advance.

 

Rgds

Fahad

 

 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!