How to show text field as pivot table metric?

[LR12345]

Hello, 

I use google sheets as my data source. Is it possible to display text field in pivot table as a metric? 

Attached file has sample input data, and expected result has what I was hoping to display using Looker studio pivot table. Thanks!