Hi,

If you run on SQL Server then have a look at the OVER clause

https://www.outsystems.com/forums/discussion/51548/aggregate-or-advance-sql/

As for to not show a value in  a cell you can check if value is same in currentrow - 1 using an if() in your cell expression.

Regards,

Daniel

hi,

# you can use query as shown in the link

# or create a function that do the total year, given input parameter Name

# in the column year total, put an expression to call that function 

http://www.sqlservertutorial.net/sql-server-window-functions/sql-server-lag-function/

The best 'Low code' way is:

• Use a Aggregate to get to whole list
• Create a function GetYearTotalByName;
  • input the list, Name and year
  • ListFilter the List on Name
  • Loop the the filtered list and sum the YearTotal

Or:

• Create a Screen with a Aggregate Group by Name with Sum(working Days)
• Create a webblock with Name as parameter (better would by the Id of the User) and use this parameter in a Aggregate of this webblock, this will get all the detail lines of Name.
• Use this Webblock in every Row in the 1st screen