Summarization Problem in Dynamic Table

[klrameet]

Hi All

I am trying to summarize the straight table that contains lot of data along with all the required columns in to a view to show the status of a report for the lastest cob date and maximum version for the event type = batch and event name = Batch and event rank = 1.

But my expression somehow is not fetching what I need ..

=IF(EVENT_RANK =1 and FEED_REPORT_STATUS_LOG_QV.EVENT_TYPE = 'Report' and FEED_REPORT_STATUS_LOG_QV.EVENT_NAME ='BATCH' ,
Aggr(FirstSortedValue(DISTINCT [FEED_REPORT_STATUS_LOG_QV.STATUS],-[FEED_REPORT_STATUS_LOG_QV.VERSION_NO]),[FEED_REPORT_STATUS_LOG_QV.COB_DATE],[FEED_REPORT_STATUS_LOG_QV.REP_NAME],EVENT_RANK))

Any pointers would be helpful .. 

@sunny_talwar 

[sunny_talwar]

How about this

FirstSortedValue(DISTINCT {<EVENT_RANK  = {1}, FEED_REPORT_STATUS_LOG_QV.EVENT_TYPE = {'Report'}, FEED_REPORT_STATUS_LOG_QV.EVENT_NAME = {'BATCH'}>} [FEED_REPORT_STATUS_LOG_QV.STATUS],-[FEED_REPORT_STATUS_LOG_QV.VERSION_NO])