Group and sort PDF report

[Ron-van-Bergen]

Hello all,
Let me be honest, I don't have much experience with appsheet.
My apps are built with a lot of research on the internet and in this forum.
I have built a well-functioning app in which I keep track of the login and logout times of my staff, I am a carpenter myself and I hire several people. now I've been working on making a pdf report for a long time, this is going well, I now have a report per week for all employees with their login times of that week.
However, what I cannot manage is a report for, for example, week 30 that contains all employees with their in and out clock times and the sum of the total number of hours worked per employee
I would like to have the report grouped by employee with the working hours for that employee below that.
I have a table with week number and year, and a table with the clock times.

My report code looks like this,

Weekoverzicht werktijden

Week:          <<[Week]>> <<[Year]>>

<<Start: ORDERBY(FILTER(Timesheet, ([Log ID] = MAXROW(Timesheet, "_ROWNUMBER", ([_THISROW-1].[Name] = [Name])))), [Name])>>

<<[Name]>>

<<Start: ORDERBY(FILTER(Timesheet, AND(([_THISROW-1].[Name] = [Name]), ([Log ID] = MAXROW(“Timesheet”, "_ROWNUMBER", AND(([_THISROW-1].[Week] = [Week]), ([_THISROW-1].[Name] = [Name])))))), [Week])>>

<<end>>

<<end>>

This are my tables

[SkrOYC]

Sample App: Invoicing and Employee expenses, Repor... - Google Cloud Community

[Tommy62 · Accepted solution]

Hier mal eine gruppierte Beispiel-Vorlage für einen wöchentlichen Bericht pro Mitarbeiter:

Wochenbericht

Mitarbeiter

<<Start:SELECT(Mitarbeiter[E-Mail],TRUE)>>

E-Mail: <<[E-Mail]>> Name: <<[_ComputedName]>>

Preis: <<[Bewerten]>>

<<Wenn: (COUNT(SELECT([Verwandte Zeitkarten][ID], [WeekNum]=WEEKNUM(NOW())))>0)>>

Zeiterfassungskarte

Datum	Zeit in	Auszeit	Berechnete Zeit	Beschreibung
<<Start: SELECT([Verwandte Zeitkarten][ID],[WeekNum]=WEEKNUM(NOW()))>><<[Datum]>>	<<[Time In]>>	<<[Auszeit]>>	<<[Berechnete Zeit]>>	<<[Beschreibung]>><<Ende>>

<<EndIf>>

<<Wenn: (COUNT(SELECT([Verwandte Arbeitszeittabellen][ID],[WeekNum]=WEEKNUM(NOW())))>0)>>

Stundenzettel

Sonne	Mo	Di	Heiraten	Do	Fr	Saß	Gesamtstunden	Gesamtbetrag
<<Start: SELECT([Verwandte Arbeitszeittabellen][ID],[WeekNum]=WEEKNUM(NOW()))>><<[Sonntag]>>	<<[Montag]>>	<<[Dienstag]>>	<<[Mittwoch]>>	<<[Donnerstag]>>	<<[Freitag]>>	<<[Samstag]>>	<<[Gesamtstunden]>>	<<[Gesamtbetrag]>><<Ende>>

<<EndIf>>

<<Ende>>