How to restrict first row

[Sra1bandi]

Hi Team,

I have a requirement to restrict first task in first row

Code	Plant	Class	Procurement Type	Workflow	WF-Formkey	Task	TaskDescription	TS_Opening_Date	TS_Closing_Date
57546	BRI1	SU	E	57546BRI1FSAP	57546BRI1	82827	Initiate Plant Extension	02-03-2025	02-03-2025
57546	BRI1	SU	E	57546BRI1FSAP	57546BRI1	83326	Initiate Plant Extension	02-04-2025	02-04-2025

Code,plant,taskdescription are main fields

for same code and same plant two tasks are created i need to select only latest task which is in 2nd row in above example like this i have multiple codes are available with two tasks for same code but i need to show only latest tasks .

Regards,

Sravan.  

[PrashantSangle]

where in front end or back end??

in front end

take straight table 

take all field as dimension

Expression - max(Task)

in backend

Load <all_fields_name_except_task>,max(task) as task from yourtable

Group by all_fields_name_except_Task;

Regards,

Prashant Sangle

[Chanty4u]

Try this 

IF(

    TS_Opening_Date = Aggr(Max(TS_Opening_Date), Code, Plant),

    TaskDescription)