Hi @michael.mccann,
We’re excited to share that you now can display metrics as rows in your pivot table 
For detail, please visit our community post here: [Launched] Show metrics as rows in Pivot Table
We look forward to your feedback once you’ve had a chance to try it! 