Need help or suggestion on building TEI STAGE report

Hello community,

Hope you all doing well.
I need some help on building pivot table or reports on my TEI.
I have TEI, and 1 program stage. The data to be collected on that stage are following:
Data elements has Tracker Domain type.

image

Option sets value:

Final purpose: produce the following tables
image
image

Question: How can I build such type of tables? How to aggregate data? How to create data dimensions?

I will appreciate any advice and real help on developing these report tables.

Thank you.
Regards, Ulanbek