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>>
And the question is?
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |