Power Platform Community Forum Thread Details

Hello

I've build a very cool model driven app that handles online training use case that capture Teams attendace report and save it to Dataverse as below data model shows

the challenge now that I need to create a monthly report that aggrgate the attenance for each group under one contract to be sent to the business for billing, and this report will touch many tables as highlighted by red arrows below

the repoort I'm planning to build is somthing similer to this one, but it's too complex that I dont even know where to start, all the data needed is saved with the proper structure on Dataverse, but the question is how to make such aggrgated report?

knowing that number of groups vary between one contract to the other, and the same for students.