How to aggregate multiple values by pivot table


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.

My redash veriosn is 8.0.