Weekly report_table

There is different unites in my table. And each of them located at different agents. The idea is to create a weekly report to remind them for unites which they are holding.
Could you help me to have a report contains;
Table 1
Column1: Agent names
Column2: Total unites located at agent side
Column3: PMC Total PMC type unite on the agent hand.
Column4: PMC Total PAG type unite on the agent hand.
Column5: PMC Total PLA type unite on the agent hand.

Table2
Column1: ULD number
Column2: Day elapsed

From attachment1 something to attachment2.