How do I create this simple pivot table?

https://www.youtube.com/watch?v=YgevJkjeFqw&list=PLUy_qbtzH0S4CkHBUvpOVpLNJluk6upOn&index=26&t=0s

here you go!

I don't think it's fair to describe the solution as poor.  It just doesn't align with your expectations (i assume Excel.)

Keep in mind that Domo visualizations and their entire approach to dashboarding initially was not designed to target Excel Jockeys, data scientists or analysts.

The target consumer of a Domo dashboard is someone who interacts with data on their phone. someone on the go.  someone who does not have the screen real estate (or desire) to scroll through content. 

You are accustomed to an Excel interactive environment but we also know that Excel tables are one of the worst ways to rapidly consume and summarize data.  Yes.  It is ubiquitous.  But no it is not 'good'.  

so ... maybe adjust your approach to communicating information to align with 'dashboarding' techniques.

No, Domo does not support Hierarchies in analyzer like you'd expect from PowerBI.  Again, the target consumer is not someone who's drilling into data looking for insights.  The assumption is, that the dimension attributes of interest are known and defined, so you'll use cards with drill paths to guide users on a curated experience.