Percentage of Text Value in Pivot Table

[CommIsh]

Hi!

I'm having a hard time getting pivot tables in Looker to show some data. My Google sheets data has only text values and I'm trying to get Looker to show the percentage of a text value in a given column.

For example, the percentage of text value A that is "yes" and then add additional text values as metrics, text value B, etc.

Hope that made sense. I can do this pretty easily in Google sheets pivot tables but can't figure it out in Looker.

Thanks!