OTBI Analysis filter by max date values
Summary
I want to filter a subject area, where I get only the max date, as the record is duplicated for different datesContent
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:
0