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;
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.
Column1: ULD number
Column2: Day elapsed
From attachment1 something to attachment2.