How to aggregate multiple values by pivot table

Hi

I wanna make table which aggregates multiple values and drilled down by multiple attributes. It seems to be impossible to implement by using redash pivot table. Plz help me if you can.
The table like the following image is what I want to make.
https://images.app.goo.gl/QQC46jY2i53SRnSU6

My redash veriosn is 8.0.