LinkedIn
Twitter
Hello all,
I have a report that starts with a empty table row.
The output looks like this,
The code for the report is:
Weekoverzicht werktijden
Week: <<[Week]>> <<[Year]>>
<<Start: ORDERBY(FILTER("Timesheet", ([Log ID] = MAXROW("Timesheet", "_ROWNUMBER", ([_THISROW-1].[Name] = [Name])))), [Name].[Employee Name])>>
<<[Name].[Employee Name]>>
Dag | Datum | In | Uit | Totaal uren |
<<Start: FILTER("Timesheet", AND(([_Thisrow].[Week] = [Week]),([_Thisrow-1].[Name] = [Name])))>><<TEXT([Date/Time In], "DDDD")>> | <<TEXT([Date/Time In],”DD-MM-YY”)>> | <<TEXT([Date/Time In],”hh:mm:ss”)>> | <<TEXT([Date/Time Out],”hh:mm:ss”)>> | <<TEXT(TIME([Total Hours]),”hh:mm:ss”)>><<END>> |
Totaal uren | <<SUM(SELECT(Timesheet[Total Hours], AND(([_Thisrow].[Week] = [Week]),([_Thisrow-1].[Name] = [Name]))))>> |
<<End>>
